Your Perfect Assignment is Just a Click Away

We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Florida State University Run Linear Multiple Regression with DV Worksheet

Florida State University Run Linear Multiple Regression with DV Worksheet

Question Description

I’m working on a statistics test / quiz prep and need guidance to help me learn.

  1. Regression Practice—Excel [Data–Data Analysis-Select Regression from Dialogue box]
  2. Anova Practice in Excel (Data-Data Analysis- Select One Way ANOVA –Single Factor in dialogue box)
  1. Please enter the following data into an Excel spreadsheet. Note make sure that you have Data Analysis Tool Pak Installed (Tools -Insert-Excel Add-ins-(click to select Data Analysis ToolPak) my version of Excel for Mac version 16.48 Microsoft 365 Subscription). If you have older versions of Excel see page 108 of Chapter 19 Excel User’s Guide, Section Loading the Data Analysis ToolPak page 108 in Exercising Essential Statistics(electronic version), if not try Help-how to install Add-ins)
  2. Run linear multiple regression with DV=EnvironSpend and IV= PopDensity and EmployGrRate

Data: Environmental Spending

City ID

EnvironSpend

PopDensity

EmployGrRate

1

0.11

149

-11.06

2

0.04

44

-5.33

3

0.26

459

13.06

4

0.07

97

-28.06

5

0.17

345

2.21

6

0.13

523

-11.83

7

0.08

24

-19.32

8

0.22

275

3.86

9

0.11

183

-16.05

10

0.1

287

19.68

11

0.2

137

11.37

12

0.11

86

46.32

Variable definitions

City ID==identification code for city

EnivronSpend=Environmental Spending=percent of annual total spending on environmental protection/concerns

PopDensity=population density=number of people per square mile)

EmployGrRate= growth rate in manufacturing employment (past 5 years)

Note: Read Chapter 19 Excel User’s Guide Section on Regression for guidance in Exercising Essential Statistics.

C. Paste output here:

Interpret results. What does it mean ?

R-Square____ Interpretation______________

Which coefficients are statistically significant and different from zero at the 5% level (Hint: p value)?

Intercept_____________________________________

Coefficient for PopDensity________________________

Coefficient for EmployGrRate_______________________

How do you visually check if the assumption of homoscedasticity is violated or not? What

scatter pattern should be visible if homoscedasticity is present (random or clear pattern)

Municipal authorities in a city are organizing a water conservation cmapaccign to educate residents to conserve water. The city officials want to know the effectiveness of different educational materials—a flyers(residential area 1, flyers and in TV ad(residential area 2), and just a TV ad(residential area 3). After the instruments are deployed, residents in each of the samples from the three areas are drawned and the respondents tested to gauge their awareness of the need for water conservations. A 10-point scale is uses with a score of 10 corresponding to the highest level of awareness and a score of 0 to the lowest level of awareness.

  1. Enter the following data into an Excel spreadsheet

Area 1 Area 2 Area 3

5 8 6

6 7 3

2 9 5

5 5 7

8 6 8

9 7 5

10 7 7

4 8 4

5 6 3

7 8 6

B. Run Anova single Factor in Excel with alpha =.05

What is the F statistic?

What is the p-value at 5 % level?

Is the Null hypothesis that the means of the three groups ranking of effectiveness of particular educational instruments to increase water conservation awareness accepted (means the same) accepted or rejected?

c Now rerun ANOVA and change the alpha value to .10

What is the F Statistic?

What is the p value at 10% level?

Is the Null hypothesis of same means accepted or rejected?

Order Solution Now

Our Service Charter

1. Professional & Expert Writers: Executive Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Executive Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Executive Papers is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Executive Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.