A+ Answers

Avg Temp	Elec Use	Elec Charge ($)	Gas Use	Gas Charge ($)
75	1589	177.55	22	29.25
72	920	107.21	15	22.50
67	699	83.00	9	16.59
52	704	83.31	64	76.04
46	807	90.28	96	112.08
32	904	99.35	155	181.96
28	888	96.93	200	245.45
33	1119	110.89	193	249.50
25	879	88.82	232	302.49
47	878	88.32	80	112.60
60	1111	115.60	27	42.84
71	1306	134.31	15	23.55
75	1778	179.60	17	23.40
75	1793	181.05	12	17.71
66	1113	115.08	16	21.33
50	742	77.79	69	75.51
47	834	81.70	71	77.38
30	833	78.60	161	157.74
30	833	78.60	161	157.70


1. Scatter plot of gas use vs. gas charge:

2. what is the Pearson r value for these two variables (do not round the answer)?

3. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)

4. What is the regression equation for the relationship between these two variables?

5. using the same Excel spreadsheet, make a scatterplot with titles comparing temperature and gas use.

6. What is the Pearson r value for these two variables (do not round the answer)?

7. What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?

8. What is the regression equation for the relationship between these two variables?

Calculations Shown

NOT RATED

Purchase the answer to view it