Please answer these all questions that ask , this is an excel file you get answer from excel formulas!

MARK STATUSASESTUDY H: WEDDING COSTS A survey was administered among Canadians, asking how much they spent on their wedding. The survey took into account tems such as venue rings, photographer, videographer, attire, flowers, music, and transportation, but excluded the honeymoon. he following data lists the response total for all these categories for each survey participant. 1,317 Assume the data set provided represents a population. 15 marks 1,529 Show your work/formulas in the highlighted cells. 1,621 1.638 1 a) Find the mean. 1,773 22,832 2,005 b) Find the median. 2,195 23,479 2.384 c) Based on the mean and median, is the data set positively skewed, negatively skewed, or symmetrical? Why? 3,507 This data is negatively skewed because Median>Mean 11,480 d) Find the standard deviation. 14,798 5816.59 15,951 e) Calculate the Interquartile Range. 15.990 5550.5 Q1 20565 16,243 f) Calculate the lower outlier boundary. Q3: 26115.5 16,368 12239.25 16,715 g) In this case, considering this data set, what might a lower outlier indicate? 16,792 The lower outlier boundary is 12239.25. Since we do have values smaller than boundary, all those can be considered lower outliers. 17,234 h) Given $28,576 is the 90th percentile, interpret 17,412 90% of the spendings on wedding are less than $28576; 10% of the list prices are greater than $28576. 17,581 17,837 2 a) Use systematic random sampling to select a sample of 30, starting at cell A20 (use cells B6 to B35). 17,871 b) What "k" value did you use? 17.980 18,121 c) The standard deviation of the sample means is called the ... 18,158 18,320 d) Determine the standard error for the sample means for this population (n=30). 18,412 18,502 e) What affect does increasing the sample size have on the standard error. 18.541 18,569 19.064 3 a) Calculate your sample mean. 19.257 19,365 b) What percent of the population's sample means (n=30) are between the population mean and your sample mean? If you're stuck, draw a curve sketch. 19.399 19,422 c) What is the probability of a sample mean being further from the population mean (than your sample mean)? If you're stuck, draw a curve sketch. 19,432 19,551 19,552 19,599 Now assume the data set provided represents a sample. 10 marks 19,717 19,744 1 a) Construct a 90% confidence interval for the population mean (copy and paste the Excel piece on cell G46). 1 a) 19,750 19,816 b) Now assume that you know sigma is $3928. What does sigma represent? 19,853 19,899 c) Now assume you know the population size is 435,000 (and sigma = $3928). 19.924 Construct a 95% confidence interval with this information. 19,926 Copy and paste the Excel piece on highlighted cell G52). 1 c ) 20.090 20,221 20,322 2 a) Management wants to know how much people are spending on wedding costs, with an allowable error of $1000. 20,369 What sample size should be used if corporate guidelines require a 99% confidence level? 20,408 Use the sample standard deviation to estimate the population standard deviation. 20.480 (Copy and paste the Excel piece on highlighted cell G58). 2 a) 20,521 20,561 b) If corporate guidelines require a 90% confidence, how does this change the sample size? 20,569 20,612 20,623 3 a) A survey found that 220 of 325 people felt people spend too much on weddings. 20,781 Develop a 90% confidence interval for the proportion of people that feel too much is 20,803 spent on weddings. 20.817 (Copy and paste the Excel piece on highlighted cell G66). 3 a) 20,887 20,926 b) In a complete sentence, summarize the meaning of this interval, as we've discussed in class. 21,004 21,104 21,116 21,154 21,218 21,337 21,358