Using the defined bins on the spreadsheet create a

Question

Problem 1- Given the data on the worksheet titled "Data for problem 1" find the following:

A) Y-intercept

B) Slope

C) R² - 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.

Attachment:- Data.rar