Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

How to construct a 90 confidence interval in excel

22/10/2021 Client: muhammad11 Deadline: 2 Day

Instructions
Confidence Interval for the Population Mean
Project Description:
The present study shows data for delivery times of international shipments for a logistics company. The company promotes its international delivery as a service that takes up to 7 days. After receiving multiple complaints that the delivery time is exceeding 7 days, the quality assurance team decided to collect data from a random sample to analyze the delivery times and decide if they should adjust the delivery time the company promises customers with. We will find the average and standard deviation for the delivery times for the random sample of shipments. We will find values from the probability table using excel functions to construct confidence intervals using different confidence levels. We will use the confidence intervals to make a conclusion about the population. We will also analyze the width of the confidence levels. Assume that the distribution of the delivery times is normal and the sample is randomly selected.
Instructions:
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. For the purpose of grading the project, you are required to perform the following tasks:
Step Instructions Points
Possible
1 Start Excel. Download and open the workbook named: 0
Confidence Interval for the Population Mean Start
2 In cell B3, find the average delivery time for the sample of shipments from the Data sheet. 5
3 In cell B4, find the standard deviation of the delivery times for the sample of shipments from the Data sheet. 5
4 In cell B5, find the size of the sample of shipments from the Data sheet. 5
Hint: use the COUNT function.
5 To build the confidence interval for the mean of the delivery times from the Data Sheet, what is the appropriate probability table to use? Choose the correct answer from the dropdown menu in cell B6. 6
6 In cell B7, find the score from the appropriate probability table to construct a 90% confidence interval. 5
Hint: use the T.INV.2T function.
7 In cell B8, find the margin of error at the 90% confidence level. 5
Hint: use the CONFIDENCE.T function.
8 In cell B9, find the upper limit for the mean at the 90% confidence level. 5
9 In cell B10, find the lower limit for the mean at the 90% confidence level. 5
10 Based on the number in cell B9 and B10, we can be 90% confident that: 5
Choose the correct answer from the dropdown menu in cell B11.
11 In cell B12, find the width of the confidence interval at the 90% confidence level. 5
12 In cell B13, find the score from the appropriate probability table to construct a 99% confidence interval. 5
13 In cell B14, find the margin of error at the 99% confidence level. 5
14 In cell B15, find the upper limit for the mean at the 99% confidence level. 5
15 In cell B16, find the lower limit for the mean at the 99% confidence level. 5
16 In cell B17, find the width of the confidence interval at the 99% confidence level. 5
17 By comparing the width of the confidence interval (CI) at 90% and 99%, what can we conclude about the width of the CI? Choose the correct answer from the dropdown menu in cell B18. 6
18 Based on the upper and lower limit values for a 90% confidence level, should the quality assurance team consider recommending that the company should change their promise to customers that they deliver international shipments within 7 days? Choose the correct answer from the dropdown menu in cell B19. 6
19 Based on the upper and lower limit values for a 99% confidence level, should the quality assurance team consider recommending that the company should change their promise to customers that they deliver international shipments within 7 days? Choose the correct answer from the dropdown menu in cell B20. 6
20 What options does the quality assurance team have to reduce their margin of error for the 99% confidence interval? Choose the correct answer from the dropdown menu in cell B21. 6
21 Save your file and submit for grading. 0
Total Score 100
Data
Shipment Time to Deliver (Days)
1 7.0
2 12.0
3 4.0
4 2.0
5 6.0
6 4.0
7 2.0
8 4.0
9 4.0
10 5.0
11 11.0
12 9.0
13 7.0
14 2.0
15 2.0
16 4.0
17 9.0
18 5.0
19 9.0
20 3.0
21 6.0
22 2.0
23 6.0
24 5.0
25 6.0
26 4.0
27 5.0
28 3.0
29 4.0
30 6.0
31 9.0
32 2.0
33 5.0
34 6.0
35 7.0
36 2.0
37 6.0
38 9.0
39 5.0
40 10.0
41 5.0
42 6.0
43 10.0
44 3.0
45 12.0
46 9.0
47 6.0
48 4.0
49 3.0
50 7.0
51 2.0
52 7.0
53 3.0
54 2.0
55 7.0
56 3.0
57 5.0
58 7.0
59 4.0
60 6.0
61 4.0
62 4.0
63 7.0
64 8.0
65 4.0
66 7.0
67 9.0
68 6.0
69 7.0
70 11.0
71 9.0
72 4.0
73 8.0
74 10.0
75 6.0
76 7.0
77 4.0
78 5.0
79 8.0
80 8.0
81 5.0
82 9.0
83 7.0
84 6.0
85 14.0
86 9.0
87 3.0
88 4.0
Questions
Confidence Interval for the Population Mean
Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.
1-2. In cell B3, find the average delivery time for the sample of shipments from the Data sheet.
3. In cell B4, find the standard deviation of the delivery times for the sample of shipments from the Data sheet.
4. In cell B5, find the size of the sample of shipments from the Data sheet.
5. To build the confidence interval for the mean of the delivery times from the Data Sheet, what is the appropriate probability table to use?
6. In cell B7, find the score from the appropriate probability table to construct a 90% confidence interval.
7. In cell B8, find the margin of error at the 90% confidence level.
8. In cell B9, find the upper limit for the mean at the 90% confidence level.
9. In cell B10, find the lower limit for the mean at the 90% confidence level.
10. Based on the numbers in cell B9 and B10, we can be 90% confident that
11. In cell B12, find the width of the confidence interval at the 90% confidence level.
12. In cell B13, find the score from the appropriate probability table to construct a 99% confidence interval.
13. In cell B14, find the margin of error at the 99% confidence level.
14. In cell B15, find the upper limit for the mean at the 99% confidence level.
15. In cell B16, find the lower limit for the mean at the 99% confidence level.
16. In cell B17, find the width of the confidence interval at the 99% confidence level.
17. By comparing the width of the confidence interval (CI) at 90% and 99%, what can we conclude about the width of the CI?
18. Based on the upper and lower limit values for a 90% confidence level, should the quality assurance team consider recommending that the company should change their promise to customers that they deliver international shipments within 7 days?
19. Based on the upper and lower limit values for a 99% confidence level, should the quality assurance team consider recommending that the company should change their promise to customers that they deliver international shipments within 7 days?
20. What options does the quality assurance team have to reduce their margin of error for the 99% confidence interval?
Sheet1
As the confidence level increases, the width of the CI increases.
As the confidence level increases, the width of the CI decreases.
The width of the CI does not depend on the confidence level.
Yes, because the interval does not contain 7 days.
Yes, because the interval contains 7 days.
No, because the upper limit of the CI is less than 7 days.
No, because the upper limit of the CI is greater than 7 days.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Smart Accountants
Smart Homework Helper
Coursework Help Online
Accounting & Finance Mentor
Quality Assignments
Accounting & Finance Specialist
Writer Writer Name Offer Chat
Smart Accountants

ONLINE

Smart Accountants

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$31 Chat With Writer
Smart Homework Helper

ONLINE

Smart Homework Helper

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$32 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$46 Chat With Writer
Accounting & Finance Mentor

ONLINE

Accounting & Finance Mentor

I am a professional and experienced writer and I have written research reports, proposals, essays, thesis and dissertations on a variety of topics.

$33 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$18 Chat With Writer
Accounting & Finance Specialist

ONLINE

Accounting & Finance Specialist

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$45 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Dp transmitter impulse line purging - Module Eight Critical Thinking Exercise - CCM-2 - Midshires College of Midwifery and Nursing - Ellis issues 6.5 five year bonds dated - Emerging trends in physical security - 1 - Analyse hsc verb scaffold - Contactcentre mycsp co uk - Counseling Adolescents - The physics classroom forces - What's your hawaiian name - How to write a case study report in counselling - Abington memorial hospital maternity - Chapter 31 health assessment and physical examination - Switchport nonegotiate best practice - Imco feeds and speeds - The old oaken bucket poem questions and answers - Pygmalion act 2 summary - Discussion for Management Class - Pandora's box 7 game list - PRJ656 Project Management Integration Framework - Apply marketing lemonade part 1 - The solar opposites lesson analyzer - Write a paper analyzing the principles of multifactorial inheritance and the role of the Nurse Practitioners in the assessment, early detection, and treatment of different genetic diseases. 2 pages APA style. - Crowned and uncrowned gear teeth - Report cover page format - Stats Assignment - Apa citation for strengthsfinder 2.0 - Growing up asian australian - Iec 62271 part 100 - Culture speech outline - Rhapsody on a windy night techniques - Woodburn primary school staff - Cambridge international as and a level economics revision guide - ACC 499 "Litigation, Censures, and Fines" - Is madagascar a disney movie - Literary analysis epic hero worksheet answers - Dicussion-----Accounting - Osu hr phone number - Nesa physics additional sample questions - Extravagant hypothesis fallacy definition and examples - Huawei antenna catalogue 2019 - Bt com shop shareholder - How to cite aicpa code of professional conduct apa - Laboratory assessment 4 cell structure and function - 300 word essay - Convert 5.667 feet to centimetres - Cat 293 skid steer - Titration of vinegar and sodium hydroxide - Origins of the universe aboriginal dreaming - Kent state stark majors - Week 1 discussion - Un2990 'life-saving appliances self-inflating msds - How is visual literacy a universal language - St giles lymphoedema clinic - 19-21 ashley avenue hoppers crossing - DQ8 - The global emotional intelligence test - Macbeth and lady macbeth relationship act 3 - BA 2010 MOD 3 Exercises - Is contrast a language technique - Disney swot analysis 2019 - Freightliner fault code 33 bulkhead - Cabcon india pvt ltd katihar - Critical milestones in strategic planning - Edu 100 week 5 journal - Marketing jobs in ratlam by procter and gamble product - Ikea's process for developing a new product - Collective noun starting with b - Jeremy kyle show foxy bingo - 1 lambda to afr - The clean clothes corner laundry - I need 1200 words on research on Augustus of Prima Porta. - A paper on discussing about 3 interesting technologies, presented at Eventbrite webinars - Kongsberg engine room simulator mc90 v download - On january boston enterprises issues bonds - 5 minutes as a percentage of an hour - Business policy - Cumulative distribution function questions - Critically assess the idea that social media are generating new forms of political protest. Discuss with reference to one of the following: the occupy movement; the Arab spring; the radical right. - Ostds certification - Caught in the crowd kate miller - Strategic management text & cases 9th edition - Immigrants by pat mora - Family health history - Organizational behavior emerging knowledge global reality 8th edition pdf - Uts law graduate attributes - Musee de l homme sarah baartman - Direct financing vs sales type lease - Doing nothing is something by anna quindlen answers - Essay - Mira spanish textbook answers - 6 1 writing traits - How can employee involvement measures motivate employees - Norman crisologo and max eigenmann son - European directorate for the quality of medicines - Four steps of tracking product costs - Virus explorer click and learn answer key - Introduction to statistics and probability