First Question Previous Question Question 2 of 12 Next Question Last QuestionUnsaved change Moving to another question will save this response. Question 2 The local council wishes to develop a model to predict the relationship between prices to install solar panels in dollars and the cost to suppliers. The Excel data file Solar.xlsx, located in the folder LBRT #3 > LBRT #3 Data Files, contains the data for fifty responders that installed solar panels and from fifty suppliers. Use Excel Data Analysis to estimate a linear model for the relationship, as well as a 99% confidence interval for the slope and a residual plot. State all numerical answers below correct to four decimal places using the Excel output results. 1. the intercept 2. the slope coefficient , and 3. the standard error of the estimate 4. Using this model, predict the price of installing a solar panel if the cost is $4.8k for the suppliers. Use all decimal places in your calculation by selecting and using the values of b0 and b1 in the output generated by Excel. Note: Write your answer in $'000. 5. Does the prediction involve extrapolating the relationship? Type yes or no. From the output for 99% confidence interval for the slope coefficient report 6. the lower bound and 7. the upper bound

Cost to supplier ('000$) 5.339 4.73 5.198 4.442 4.897 4.312 5.327 5.165 5.322 4.203 4.562 4.228 3.998 4.09 4.346 4.204 4.235 4.958 4.491 4.062 4.929 4.322 5.43 5.011 4.946 4.968 4.861 4.135 3.698 5.322 3.872 3.784 3.862 4.056 5.416 4.614 3.96 5.264 4.331 4.433 5.055 3.562 4.177 4.204 4.629 4.93 4.452 3.779 4.19 5.051 Price for Consumer ('0005) 5.932 7.49 5.732 7.256 6.104 7.122 7.492 6.639 6.401 6.367 7.069 6.176 6.707 5.699 7.39 6.478 6.832 6.946 6.088 7.006 6.027 6.289 6.608 7.398 5.754 6.301 6.129 6.933 6.005 7.397 6.067 5.904 5.566 6.902 6.749 5.9 7.083 6.04 7.49 6.058 7.178 7.366 5.891 6.247 7.14 6.396 6.681 5.754 6.475 6.122 Cost to supplier ('000$) 5.339 4.73 5.198 4.442 4.897 4.312 5.327 5.165 5.322 4.203 4.562 4.228 3.998 4.09 4.346 4.204 4.235 4.958 4.491 4.062 4.929 4.322 5.43 5.011 4.946 4.968 4.861 4.135 3.698 5.322 3.872 3.784 3.862 4.056 5.416 4.614 3.96 5.264 4.331 4.433 5.055 3.562 4.177 4.204 4.629 4.93 4.452 3.779 4.19 5.051 Price for Consumer ('0005) 5.932 7.49 5.732 7.256 6.104 7.122 7.492 6.639 6.401 6.367 7.069 6.176 6.707 5.699 7.39 6.478 6.832 6.946 6.088 7.006 6.027 6.289 6.608 7.398 5.754 6.301 6.129 6.933 6.005 7.397 6.067 5.904 5.566 6.902 6.749 5.9 7.083 6.04 7.49 6.058 7.178 7.366 5.891 6.247 7.14 6.396 6.681 5.754 6.475 6.122