Mathematics Homework Help

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?