Calculating regression equation

Reference no: EM1315648

Q1) Data given are temperatures on arbitrarily selected days in a summer class and number of absences on those days.

Temperature, x	72	85	91	90	88	98	75	100	80
Number of absences, y	3	7	10	10	8	15	4	15	5

a) Determine equation of regression line for the given data. Round the line values to the nearest two decimal places. Illustrate your work.

b) Using equation found in part a, forecast number of absences when temperature is 95.

Q2) Create a 1,000 - 1,500 word paper applying Regression and Correlation to personal or business application student is familiar with. Paper needs the collection of interval or ratio level data which appears to be correlated. Utilizing Regression function and graphing function in Excel, calculate mean, median and mode for both sets of data, and computation and interpretation of coefficient of correlation, coefficient of determination. Additionally, use graphing function to graph data and calculate regression equation. Once all of these numbers are computed, interpret meaning of all the numbers.

Reference no: EM1315648

Questions Cloud

Testing our research hypothesis : Discuss possible study designs. Which of the designs would we use to test our research hypothesis?

Find expected dividend payout ratio : Calculation of Dividend Payout ratio - If the firm follows a residual dividend policy and has no other projects, what is its expected dividend payout ratio?

Programming field as career : Unfortunately, there are fewer women within the programming fields that there are men, encourage women to go into these fields

Questions based on dividend policy : Multiple choice questions on Dividend Policy and Matrix Corporation follows the residual dividend policy. In a year with an exceptionally large capital budget and normal earnings, the firm would most likely

Calculating regression equation : Additionally, student should use graphing function to graph data and calculate regression equation.

Determining confidence interval for the mean price : Find the confidence interval for the mean price, μ, of all dealer sticker prices of new cars: for a confidence level of 90% in thousands of dollars:

Find correct answer on weighted average cost of capital : Find correct answer on weighted average cost of capital for Campbell Co. is trying to estimate its weighted average cost of capital (WACC)

Computation of cross price elasticity of demand : For each of the following pairs of goods, would you expect the cross-elasticity of demand to be positive or negative? Large (in absolute value) or small? Defend your answers:

Determine expected dividend yield and capital gain : Determine expected dividend yield and Capital Gain - Find the expected dividend yield and capital gain yield once Fast Start Inc.'s period of supernormal growth ends.

User Account

All Pages