CITYWIDE FITNESS CENTER, INC. – QUESTIONs

Your firm has been hired by Citywide Fitness Center to provide an analysis of the situation. Write a report using the report writing guide from the course website. What issues must be addressed in the case? Citywide Fitness Center is concerned with input on the following questions:

Q. 1. Using the Excel data set found on the course web site, perform linear regression analysis to obtain an equation to predict age at death given a specific cholesterol level. Predict the age at which Tommy will die given his cholesterol level is 310 mg/dL. Interpret the slope and the coefficient of determination in the context of this problem. Perform a statistical hypothesis test of the slope and interpret the P-value.

Q. 2. Suppose it costs $2,500 to buy a defibrillator. Find the expected value of owning a defibrillator if there is a 4% probability that Citywide Fitness Center will lose a lawsuit regarding its operation, with each lawsuit resulting in Citywide Fitness Center being liable in the amount of $250,000.

and may i have the excel sheet like the chart too in my paper
each question in one page and if it need any formula just pls have that one also