Question: An excerpt from Excel s regression output for the data set
An excerpt from Excel's regression output for the data set of student marks on the second test and the final exam in a statistics course, described in Exercise 11, is shown below in Exhibit 13.48. Using the output, test for evidence of a positive slope between the two variables, with α = 5%.
Answer to relevant Questionsa. If appropriate, construct a 95% confidence interval estimate for the average exam mark of students who had a mark of 65% on the second test of a statistics course (using the data set described in Exercise 11). b. If ...What is the relationship between revenue and profit? A random sample of the top 1,000 Canadian companies was selected, and revenue and profit for 2008 were recorded.6 Create a scatter diagram, and comment on the ...Why is it not recommended to make predictions outside the range of the sample data on which the regression relationship is based? Apply the formula for the adjusted R2 to verify the value shown in Exhibit 14.17. Note that the SSE and SST are shown in the Excel Regression output. For the Salaries data set, create a multiple regression model that includes all the possible explanatory variables. Interpret this model. Are there any obvious difficulties with this model?
Post your question