Using the Excel spreadsheet provided in this week's lesson with energy data regarding temperature, electric use, electric
No answer yet for this question.
Ask a Tutor
Question:
- Using the Excel spreadsheet provided in this week's lesson with energy data regarding temperature, electric use, electric cost, gas use, and gas cost for 19 months, make a scatter plot with titles comparing gas use and gas cost as explained in the Week 5 presentation in slides 9-14. Make the x-axis "gas use" and the y-axis "gas cost".Copy and paste the scatter plot here:
- What is the Pearson r value for these two variables (do not round the answer)?
- What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?
- What is the regression equation for the relationship between these two variables?
- Using the same Excel spreadsheet, make a scatter plot with titles comparing temperature and gas use. Make the x-axis "temperature" and the y-axis "gas use". (You may find it easiest to first delete the two intervening columns in the spreadsheet.)Copy and paste the scatter plot here:
- What is the Pearson r value for these two variables (do not round the answer)?
- What is the statistical significance (two-tailed p value) for these two variables (do not round the answer)?
- What is the regression equation for the relationship between these two variables?
Posted Date: