Question 7 1/ 1 point The city of Oakdale wishes to see if there is a linear relationship between the temperature and the amount of electricity used (in kilowatts). TemperatureKilowatts (x) (y) 73 680 78 760 85 9210 98 1510 93 1170 83 888 92 923 81 837 76 600 105 1800 Approximately what percentage of the variation in Kilowatts is accounted for by Temperature in this model? Place your answer, rounded to 1 decimal place, in the blank. Do not use any stray punctuation marks or a percentage sign. For example, 78.9 would be a legitimate entry. __ % Answer: 89.3 w Hide question 7 feedback The R-squared value is the amount of explained variance in the data points in the model. You convert this decimal to a percent. Copy and Paste the Data into Excel. Data -> Data Analysis -> Scroll to Regression Highlight Kilowatt for the Y Input: Highlight Temperature for the X Input: Make sure you click on Labels and Click OK If done correctly then Multiple R = 0.944907859 R Square = 0.892850862 89.3% of variation in the Kilowatts is accounted for by Temperature in this model. Note: Correlation is a value between -1 and 1. This STAYS a decimal. R-square gets converted from a decimal to a percentage. The Correlation IS NOT a percent, leave it as a decimal.
