(Answered) Submit one excel file put each problem result on a separate

Statistics

Submit one excel file. Put each problem result on a separate sheet in your file. Please show all work/formulas in excel only!

10.45 A problem with a telephone line that prevents a customer from receiving or making calls is upsetting to both the customer and the telecommunications company. The file Phone contains communications company and the time to clear these problems (in minutes) from the customers' lines.

A. At the 0.05 level of significance, is there evidence of a difference in the variability of the time to clear problems between the two central offices?

b. Determine the p-value in (a) and interpret its meaning.

c. What assumption do you need to make in (a) about the two populations in order to justify your use of the F test?

d. Based on the results of (a) and (b), which t test should you use to compare the mean time to clear problems in the two central offices?

View complete question

Statistics and Probability, Statistics

Category:- Statistics and Probability
Reference No.:- M91873137
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Statistics and Probability

Diastolic blood pressures are approximately normally

Diastolic blood pressures are approximately normally distributed with a mean of 75 and a standard deviation of 10. If we consider samples of 20 patients, what is the 90th percentile of the mean diastolic blood pressure?

You want to retire in 35 years to fund the retirement you

You want to retire in 35 years. To fund the retirement, you deposit $25,000 into an account now, and you deposit $20,000 five years from now. You also plan to save an equal amount each year between now and 35 years from ...

Sixty-seven percent of adults have looked at their credit

Sixty-seven percent of adults have looked at their credit score in the past six months. If you select 31 customers, what is the probability that at least 20 of them have looked at their score in the past six months?

A budgeting web site reported thatnbsp20nbspof us

A budgeting Web site reported that 20?% of U.S. households have withdrawn money from a? 401(k) or other retirement account for needs other than retirement in 2013. A random sample of 11 U.S. households was selected. Comp ...

A manufacturer obtains clock-radios from three different

A manufacturer obtains? clock-radios from three different? subcontractors: 10?% from? A, 30?% from? B, and 60?% from C. The defective rates for these subcontractors are 3?%, 2 %, and 5?% respectively. If a defective? clo ...

A national center for health statistics report based on

A National Center for Health Statistics report based on 1985 data states that 30 percent of American adults smoke. Consider a simple random sample of 17 adults. Find the probability that the number of smokers in the samp ...

What types processes or procedures support project

What types processes or procedures support project management, continuous improvement and innovative initiatives?

Xyz corporations budgeted monthly sales are 10000 and they

XYZ Corporation's budgeted monthly sales are $10,000, and they are constant. Its customers pay as follows: 30% pay in the first month and take the 2% discount, while the remaining 70% pay in the month following the sale ...

A hypothetical population consists of eight individuals

A hypothetical population consists of eight individuals ages 13, 15, 17, 21, 22, 23, 26, and 30 years. (Enter your answers to three decimal places.) (a) What is the probability that a person in this population is a teena ...

Butterfly tractors had 1850 million in sales last year cost

Butterfly Tractors had $18.50 million in sales last year. Cost of goods sold was $8.90 million, depreciation expense was $2.90 million, interest payment on outstanding debt was $1.90 million, and the firm's tax rate was ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Statistics and Probability Expert