1. Insurance companies track life expectancy information to assist in determining the cost of life insurance policies. Life expectancy is a statistical measure of average time a person is expected to live, based on a number of demographic factors. Mathematically, life expectancy is the mean number of years of life remaining at a given age, assuming age-specific mortality rates remain at their most recently measured levels. Last year the average life expectancy of all the Life Insurance policyholders in Ontario at age 65 was 22.3 years (meaning that a person reaching 65 last year was expected to live, on average, until 87.3). The insurance company wants to determine if their clients now have a longer average life expectancy, so they randomly sample some of their recently paid policies. The insurance company will only change their premium structure if there is evidence that people who buy their policies are living longer than before. The sample data is provided in the excel file. Answer the following questions. Results should be support by excel output.

a. Construct a 95% and 99% confidence intervals for the true average life expectancy. Use t-distribution and Descriptive Statistics function from Data Analysis. Interpret each Confidence interval and comment on the difference between the 95% and 99% interval.

b. Write the null and alternative hypotheses for this test:

c. In this context, describe a Type I error possible. How might such an error impact Life Insurance company’s decision regarding the premium structure?

d. What is the value of the t-test statistic?

e. What is the associated P-value?

f. State the conclusion using α = 0.05. Do it using both P-value and critical value.

Please answer it on excel. Thank you.

1. You have 4 groups with an overall sample size of n = 20. The F critical value at the alpha = 0.05 level of significance is 3.24. Complete the following 1 factor ANOVA table below:

Is there a significant difference (α=0.05) between at least two of the four groups for the analysis in question 1 (above)? (circle one) YES NO

2. Use the following data set to complete the ANOVA table and answer the questions.

Is there a significant difference (α=0.05) between at least two of the four groups for the analysis in question 1 (above)? (circle one) YES NO

Confidence interval for Group 1 ( _________ , _________)

Confidence interval for Group 2 ( _________ , _________)

Confidence interval for Group 3 ( _________ , _________)

Is Group 1 significantly different from Group 2 at the α=0.05 level of significance YES NO

Is Group 1 significantly different from Group 3 at the α=0.05 level of significance YES NO

Is Group 2 significantly different from Group 3 at the α=0.05 level of significance YES NO

1. You have 4 groups with an overall sample size of n = 20. The F critical value at the alpha = 0.05 level of significance is 3.24. Complete the following 1 factor ANOVA table below:

Is there a significant difference (α=0.05) between at least two of the four groups for the analysis in question 1 (above)? (circle one) YES   NO

2. Use the following data set to complete the ANOVA table and answer the questions.

Is there a significant difference (α=0.05) between at least two of the four groups for the analysis in question 1 (above)? (circle one) YES   NO

Confidence interval for Group 1 ( _________ , _________)

Confidence interval for Group 2 ( _________ , _________)

Confidence interval for Group 3 ( _________ , _________)

Is Group 1 significantly different from Group 2 at the α=0.05 level of significance YES NO

            Is Group 1 significantly different from Group 3 at the α=0.05 level of significance YES NO

            Is Group 2 significantly different from Group 3 at the α=0.05 level of significance YES NO

If sales are $812,000, variable costs are 60% of sales, and operating income is $200,000, what is the contribution margin ratio?

a.44% b.56% c.40% d.60%

1· The dentists in a dental clinic would like to determine if there is a difference betweenth0 number of new cavities in people who eat an apple a day and in people who eat less

than one apple a week. They are going to conduct a study with 50 people in each group.

Fifty clinic patients who report that they routinely eat an apple a day and 50 clinic patients who report that they eat less than one apple a week will be identified. The dentists will examine the patients and their records to determine the number of new cavities the patients have had over the past two years. They will then compare the number of new cavities in the two groups.

(a) Why is this an observational study and not an experiment?

(b) Explain the concept of confounding in the context of this study. Include an example of a possible confounding variable.

a) besides the soccer ball shape (20 hexagons, 12 pentagons), are there other polyhedrons composed of just pentagons and hexagons? Using Euler's formula of polyhedrons, prove what other polyhedrons are made of pentagons and hexagons.

b) Is this breakdown of edges 50/50? That is, must there be an equal number of edges adjacent one pentagon and one hexagon as there are edges between two hexagons? If claim so, justify your claim and if you believe there is another ratio, explain why this ratio must be correct.

We interviewed two groups of 50 college students respectively from UIC and DePaul to know if they rather watch NFL Football vs. some other sport on Sunday.

Actual Data

Based on the statistics above, we need to determine if there is a relationship between the university of a student and watching Football. Answer to the following questions to arrive at the conclusion.

• What are Ho and Ha?
• What are the chi-square values?
• What is the degrees of freedom?
• What is the p-value?
• For alpha=0.05, what would be our statistical conclusion?
• Write out the full conclusion in English

Please show work

Sunrise has two divisions: East and Midwest. Sunrise has a minimum required rate of return of 8%. In 2019, the East division has average operating assets of 50 million, net operating income of $5 million, and sales of $100,000 million. In 2019, the Midwest division has average operating assets of 20 million, net operating income of $2.5 million, and sales of $25,000 million. Please (1) use both ROI and the residual income model to evaluate these two divisions' managerial performance and provide comment on which manager performed better; (2) use margin and turnover ratios to compare two divisions' operating strategies.

Sun has two divisions: East and Midwest. Sun has a minimum required rate of return of 8%. In 2019, the East division has average operating assets of 50 million, net operating income of $5 million, and sales of $100,000 million. In 2019, the Midwest division has average operating assets of 20 million, net operating income of $2.5 million, and sales of $25,000 million. Please (1) use both ROI and the residual income model to evaluate these two divisions’ managerial performance and provide comment on which manager performed better; (2) use margin and turnover ratios to compare two divisions’ operating strategies.