GWU Statistics Weekly Food Consumption Excel Spreadsheet

User Generated

fxvmmyrf31

Mathematics

George Washington University

Description

All work must be show on the attached Excel document (:

Each question should be clearly labeled and put on a separate sheet in the excel doc.

The final product should be the attached excel doc with a sheet for each question (For a total of 4 sheets).

Unformatted Attachment Preview

Family 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 38 39 40 41 42 43 Weekly food expense $198.23 $143.53 $207.48 $134.55 $182.01 $189.84 $170.36 $163.72 $155.73 $203.73 $191.19 $172.66 $154.25 $179.03 $130.29 $170.73 $194.50 $171.14 $175.19 $177.25 $166.62 $135.54 $141.18 $158.48 $159.78 $157.42 $98.40 $181.63 $128.45 $190.84 $154.04 $190.22 $161.48 $113.42 $148.83 $197.68 $135.49 $146.72 $176.62 $154.60 $178.39 $186.32 $157.94 This is fictitious data. 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 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 $116.35 $136.81 $195.58 $129.44 $146.84 $165.63 $158.97 $210.00 $175.46 $159.69 $154.56 $152.95 $177.30 $129.23 $127.40 $167.48 $183.83 $157.39 $163.24 $165.01 $137.43 $177.37 $142.68 $150.04 $161.44 $166.13 $190.96 $187.19 $116.63 $159.73 $159.64 $142.44 $153.03 $143.12 $156.35 $182.70 $129.03 $119.06 $137.99 $144.20 $183.51 $169.67 $134.66 $202.94 88 89 90 91 92 93 94 95 96 97 98 99 100 $143.43 $170.52 $139.53 $159.31 $134.77 $165.48 $127.20 $168.16 $125.39 $167.96 $178.64 $134.38 $111.87 a. 1. A sample of 15 quality control managers with more than 20 years experience have an average salary of $68,000. The historical standard deviation of the salary for quality managers with at least 20 years of experience is $19,000. Calculate a 95% confidence interval for the mean salary for all quality managers with at least 20 years of experience. b. What size sample is needed to ensure that you can estimate the population mean salary of all quality managers with more than 20 years of experience and have only one chance in 100 of being off by more than $500? a. 2. The widths of 100 elevator rails have been measured. The sample mean and standard deviation of the elevator rails are 2.05 inches and 0.01 inch. Calculate a 95% confidence interval for the average width of an elevator rail. b. Assume that the population standard deviation is also 0.01 inch. How large a sample of elevator rails would you have to measure to ensure that you could estimate, with 95% confidence, the average diameter of an elevator rail within 0.001 inch? 3. A study is performed in a large southern town to determine whether the average amount spent on food per four-person family in the town is significantly different from the national average. A random sample of the weekly grocery bills of four-person families in this town is given in the file P09_06.xlsx. Assume the national average amount spent on food for a four-person family is $153 and that we know from historical data that the population standard deviation is $25. a. Identify the null and alternative hypotheses. b. What are the critical values when a = 0.01,0.05? Is there evidence that the average amount spent on food for families in the town is significantly different from the national average if a = 0.01? What is the test statistic and the p-value? d. Would your inference from part c change if a = 0.05? Sketch the distribution of test statistic when the null is true, and shade the area that corresponds to the p-value. c. 4. A bank wonders whether offering a higher cash back percent would increase the amount charged on its credit card. The bank makes this offer to randomly selected 85 of its existing credit card customers. It then compares how much these customers charge this year with the amount that they charged last year. The mean increase in the amount charged for the sample is $312, and the sample standard deviation is $1327. a. Give a 95% confidence interval for the mean amount of the increase. b. Is there significant evidence at the 1% level that the mean amount charged increases under the higher cash back offer? State Ho and HA and carry out a z test. Sketch the distribution of test statistic when the null is true, and shade the area that corresponds to the p-value.
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

View attached explanation and answer. Let me know if you have any questions.Hey there, I hope you are doing wellHere you will find the Excel document with the procedure and answers to your questionsPlease, let me know if you have any questions about it😀 If you double click in any of the calculations numbers, you will see the formula I used to calculate the T-test, p-value, etc

Family
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
38
39
40
41
42
43

Weekly food expense
$198.23
$143.53
$207.48
$134.55
$182.01
$189.84
$170.36
$163.72
$155.73
$203.73
$191.19
$172.66
$154.25
$179.03
$130.29
$170.73
$194.50
$171.14
$175.19
$177.25
$166.62
$135.54
$141.18
$158.48
$159.78
$157.42
$98.40
$181.63
$128.45
$190.84
$154.04
$190.22
$161.48
$113.42
$148.83
$197.68
$135.49
$146.72
$176.62
$154.60
$178.39
$186.32
$157.94

This is fictitious data....


Anonymous
Just what I needed…Fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags