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

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