When writing the equation for this question, you may round your intercept and slope coefficients to nearest hundredth.Įquation given by running multiple linear regression:

run the regression only ONCE using ALL X-variablesĪnd answer this question (and the ones that follow) questions based on the resulting output.īe sure to include residuals and residual plots, and use a 95% confidence level when running your regression. Note that you are NOT to utilize the Principle of Parsimony in this quiz, i.e. Output appears on a new sheet within this Excel file. When it asks where you'd like to place your regression output, select a new sheet so that the regression However, to obtain this equation you'll need to run Write in the final equation in the highlighted cell below. Use the data to answer the following 6 questions:ġ) (1 point) What is the regression equation for Demand in terms of Income, Temp, and Price variables? 'Temp' represents average yearly temperature (in Fahrenheit), and 'Income' represents per capita income per year (in thousands) Represents cans of pop consumed per capita per year, 'Price' represents average price of a 6-pack of pop (in ), SOLVED: The data in columns A, B, C and D represent imaginary data from all 50 states regarding soda consumption.

Simple linear regression equation excel