Question: Can this be calculated in excel? If yes, please include excel formula/excel functions. Thanks. Sales personnel for Skillings Distributors submit weekly reports listing the customer

Can this be calculated in excel? If yes, please include excel formula/excel functions. Thanks.

Sales personnel for Skillings Distributors submit weekly reports listing the customer contacts made during the week. A sample of 55 weekly reports showed a sample mean of 17.5 customer contacts per week. The sample standard deviation was 5.6. Provide 90% and 95% confidence intervals for the population mean number of weekly customer contacts for the sales personnel.

90% Confidence, to 2 decimals:

(,)

95% Confidence, to 2 decimals:

(,)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

please answer with detail working please answer in text using Excel or word only #8. Sales personnel for Skillings Distributors submit weekly reports listing the customer contacts made during the...

Help, and please show work - Thanks! A simple random sample of 80 items resulted in a sample mean of 90. The population standard deviation is a = 5. (a) Compute the 95% condence interval for the...

midterm ACCOUNTING I FINAL EXAM This final exam includes a comprehensive assignment, described below, and an assignment on the last tab where you will complete journal entries for a merchandising...

PLEASE MAKE SURE FORMATTING IS UNDERSTANDING AND READABLE! I have arranged the questions in the order they should be in, please only provide answer with section, question number and part (ex. 1a, 1b,...

Please tap the answer. Do not handwrite. Thank you Find the t value(s) for each of the following cases. Round your answers to 3 decimal places. Enter negative values as negative number. a. Upper tail...

I need help with this project. I have attached all of the instructions and relevant information. The final draft is due August 20th. Course Project: A Financial Statement Analysis A Comparative...

Can someone help me with the Accounting Course Project. Instructions are there in the Course Project Instruction and the 10k for Nike and UNder Armour attached. I have also attached the Teamplate....

Please show work Sales personnel for Skillings Distributors submit weekly reports listing the customer contacts made during the week. A sample of 65 weekly reports showed a sample mean of 19.5...

Review an Annual Report to gain a general understanding of the types of financial information contained in the report and why that information might be useful to a potential reader. You will also be...

Two segments (Mountain Bike and Road Bike) showed the following data for the most recent year: Mountain Bike Road Bike Contribution to indirect expenses $ 840,000 $ 504,000 Assets directly used by...

What do you think of Walmart's strategy in Mexico and Central America, and how have bilateral agreements and geographic proximity played a role in its success? What impact do you think the...

XO Group compensates top management using stock options. On January 1, Year 1, XO issued 36,000 options to purchase $1 par value common stock for $20 per share (which is the current stock price) The...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...