Calculate the regression, In Milky Way Galaxy, a class of

Calculate the regression

Reference no: EM1376348

Somewhere in the Milky Way Galaxy, a class of 2,000 students took a course in Astronomy. The first exam scores and the final exam percentage reached earth, but transmission broke off after only a dozen students' scores were received. This is the only data available about that class. That information is in the table below.
Student Exam 1 Final
Scorpio 85 76
Andromeda 80 77
Pictor 70 72
Tucana 85 88
Vulpecula 80 76
Crux 85 83
Perseus 40 55
Orion 75 77
Cassieopia 80 72
Ursa 55 73
Centaurus 70 71
Hydrus 85 81
Use these data to answer the following questions
a. Find the slope and the intercept term for Final = a + b Exam1. Please show work/steps.

b. Use Excel to calculate the regression. Show numbers as two decimal places even if, 0.00.

Reference no: EM1376348

Questions Cloud

Estimate potential sales of employer product : Suppose you have been employed as an economic analyst, your job is to use the Regression Model to estimate potential sales of your employer's product.

Major problem in projecting a trend line : A Taiwan electronics corporation exports personal computers to the United States Their PC sales over the past five years are following:

Independent variables of a regression equation : Determine which of the following refers to a relatively high correlation among independent variables of a regression equation?

Advantage of the production function : A major advantage of production function is that it can be easily transformed into a linear function, and thus can be analyzed with the linear regression method.

Calculate the regression : In Milky Way Galaxy, a class of 2,000 students took a course in Astronomy. The 1st exam scores and final exam percentage reached earth, but transmission broke off after only a dozen students' scores were received.

Question about human capital model : A labor economist estimates a regression of log earnings on schooling, experience, ability, as measured through, and interactions in schooling and experience,

Find the estimated elasticity of demand : A customer has provided information on the value of cars, the price of gasoline, the quantity of new cars sold in United States. Gross Domestic Product per capita is also observed.

Concept of beta and the risk trade off : If beta of portfolio is .326, the present yield to maturity on United States government bonds maturing in one year and an assessment that market risk premium.

Statistical significance of the parameter : Wilpen Corporation, a price-setting company, manufactures nearly 80% of all tennis balls purchased in the United States.

User Account

All Pages