SYM 506 GCU Business Probability, Statistics & Confidence Intervals Excel Worksheet

User Generated

Wnu2avpr

Mathematics

Sym 506

Grand Canyon University

SYM

Description

Based on the date you collected (collected data attached as a file below);

*** Create confidence intervals related to the interval and ratio-level data you collected and answer the following questions.

  • What is the best estimate of the population mean.
  • Develop a 95% confidence interval for the population mean. Develop a 90% confidence interval for the population mean. Develop a 98% confidence interval for the population mean.
  • Interpret the confidence interval. Detailed interpretation is key.

*** Create an individual Excel document for each of the required items and be sure to show work with formulas and details of explanations.

APA format is not required, but solid academic writing is expected.

Unformatted Attachment Preview

Лист1 Approximately, What Amount Have You Been Spending Grocery Shopping Online, After the COVID-19 Pandemic? 0-99 100-199 200-299 300-399 400-499 500-599 600-699 Midpoint Frequency 49.5 5 149.5 249.5 349.5 449.5 549.5 649.5 6 4 12 8 1 1 Approximate Amount Spent Sh 37 Frequency Spending in Dollars 7 6 5 4 3 2 1 0 0 Страница 1 50 Лист1 Approximate Amount Spent Shopping Online for Groceries Chart Title 14 12 10 8 6 4 2 100 150 200 250 300 0 49.5 Midpoint (dollars) Страница 2 149.5 249.5 349.5 Лист1 Chart Title 349.5 449.5 549.5 649.5 Страница 3 Changes in Online Grocery Shopping during the COVID-19 Pandemic The following are data collected from 37 people at my place of work on much they spend on online groceries per week and how the new shopping experience is for them. Individuals 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Sex Male Female Female Female Female Female Male Male Female Female Male Female Female Female Female Male Female Female Male Female Female Female Female Female Female Male Male Female Male Male Female Female Female Female Female Male Female Age Dollar Spent ($) 27 32 25 41 29 54 36 25 51 28 27 52 44 41 36 33 29 26 30 51 40 27 37 43 54 56 49 35 29 31 28 41 42 37 43 55 40 50 600 100 270 300 410 100 370 180 480 250 370 240 150 220 360 300 550 310 440 160 310 360 90 470 310 60 380 40 350 80 420 450 380 120 430 490 Experience (Satisfaction) Strongly Diagree Strongly Agree Strongly Disagree Agree Agree Agree Strongly Disagree Disagree Agree Strongly Agree Disagree Neither Agree nor Disagree Disagree Disagree Agree Strongly Agree Agree Strongly Agree Disagree Strongly Agree Disagree Neither Agree nor Disagree Strongly Agree Disagree Strongly Agree Neither Agree nor Disagree Disagree Strongly Agree Disagree Strongly Agree Strongly Disagree Agree Strongly Agree Neither Agree nor Disagree Disagree Strongly Agree Strongly Agree Online grocery shopping during the COVID Pandemic has been a great experience? Response Strongly Disagree Disagree Neither Agree nor Disagree Agree Strongly Agree Total Frequency Cummulative Frequency 4 10 4 7 12 37 4 14 18 25 37 Approximately, What Amount Have You Been Spending on Grocery Shopping Onlin Spending in Dollars 0-99 100-199 200-299 300-399 400-499 500-599 600-699 Frequency 5 6 4 12 8 1 1 37 Class Midpoint 45 145.5 245.5 345.5 445.5 545.5 645.5 been a great experience? Percentages 11% 27% 11% 19% 32% 100% n Grocery Shopping Online, Percentage 13% 16% 11% 32% 22% 3% 3% 100%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: CONFIDENCE INTERVAL

Confidence Interval
Student’s Name
Institutional Affiliation

1

CONFIDENCE INTERVAL

2
Confidence Interval

Confidence interval in statistics explains a range of values by which a selected
probability that a specified value within a parameter lies within the estimated interval (Bell,
Bryman, & Harley, 2018). The confidence interval provides us with an upper and lower limit
around an estimated sample mean, by which one is confident of capturing a population mean.
The paper examines the confidence interval for sample data collected from 37 employees
concerning the staff spending per week in an online grocery store and their experience during the
COVID-19 global crisis.
Discussion
The employees spend an average of 295 dollars in the online grocery store from the
collected data, with a standard deviation of 151 dollars. Besides, the staff that spent the most
amount on groceries spend 600 dollars and a minimum of 40 dollars.
95 Percent Confidence Interval
The 95 % confidence interval for the ...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags