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.