math question excel assignment

Anonymous
timer Asked: Oct 22nd, 2018
account_balance_wallet $5

Question Description

excel assignment

excel assignment

excel assignment

excel assignment

Unformatted Attachment Preview

Team: Team Memebers Present 1 2 3 4 (1) A random sample of 20 taste-tester Ratings 16 20 31 50 50 50 51 53 53 55 57 59 60 60 61 65 67 67 81 92 mple of 20 taste-testers rate the quality of a proposed new product on a 0-100 scale. The order (a) Calculate a 95% confidence interval for the population mean score. (b) Recalculate the confidence interval but with a 90% confidence level for the same po (c) Which is wider, the 90% interval or the 95% interval? a 0-100 scale. The ordered scores are ce level for the same population mean. Consumer ID 1 2 3 4 5 6 7 8 9 10 11 12 13 Product Preference Competitor Client Competitor Competitor Competitor Competitor Client Client Client Client Client Client Client (2) A random sample of consumers expres (a) Construct a 99% confidence interval for 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 None Client Client None Competitor Client Competitor Competitor Competitor Client Client Competitor None Competitor None Client Client Client Competitor None (b) Would a 95% confidence interval for the (c) The marketing director of your client's c Based on your answer to part (a), do you ag 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 Client Competitor Client Competitor Client Competitor Client Competitor Client Competitor Client Competitor Client Client Client Competitor Competitor Client Client Client Client Client Competitor Competitor Client Competitor Client Competitor Competitor Competitor Client Competitor None Client Client Client Client 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 Competitor Competitor Client Competitor None Client Client Client Client None Client Client Competitor Client Client Competitor Competitor Client Client Competitor Client Client Competitor Client Competitor Client Competitor Competitor Client Client f consumers express their product preference between your client's product, a competitor's p nfidence interval for the population proportion who prefer your client's product. ence interval for the same population proportion be wider or narrower. tor of your client's company states, "I am almost certain that our product is preferred by at leas oduct, a competitor's product or no preference . (3) While you and a friend were attending an Eagles play-off game with free t You are skeptical and randomly ask 4 people in your section what they paid f The prices are listed here. Ticket Price $ 225.00 $ 140.00 $ 50.00 $ 100.00 (a) Construct a 95% confidence interval f (b) Based on this data and confidence int (c) Assume you increased the sample size Construct a 90% confidence interval for t Based on this larger sample, can you be c off game with free tickets you won as a prize, your friend claimed that the average ticket price ased the sample size to ten and the sample mean and sample standrad deviation remained unc dence interval for the average ticket price in your section using this new assumption. average ticket price in your section was at least $200. ...
Purchase answer to see full attachment

Tutor Answer

julian123
School: University of Maryland

Got It some recheck thanks.

Team:
Team Memebers Present
1
2
3
4

(1) A random sampl...

flag Report DMCA
Review

Anonymous
Thank you! Reasonably priced given the quality not just of the tutors but the moderators too. They were helpful and accommodating given my needs.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors