excel

Problem 1.

Given the data on the worksheet titled “Data for problem 1” find the following:

A) Y-intercept

B) Slope

C) R2 – correlation coefficient

D) Find by extrapolation (using the equation of a line with your computed parameters) the

value of Y if x = 36 seconds

Place your answers on the spreadsheet.

Problem 2.

Given the data on the worksheet titled “Data for problem 2” find the following:

A) Average

B) Median

C) Standard deviation

D) Kurtosis

E) Skew

F) Count

G) Max

H) Min

I) Using the defined “bins” on the spreadsheet. Create a histogram that shows how many

values are in each group.

Place your answers on the spreadsheet.

Upload your spreadsheet with answers to moodle.