2
>
Don't use plagiarized sources. Get Your Custom Essay on
Excel project help needed
Just from $13/Page
Golden Food
| C |
ompany
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Golden Food Company
| Golden Food Co.:
| D |
own River Plant
| Matcha Whipped Spread |
| Weight (oz) |
Statistical Output
| A |
nalysis
|
|
|
|
|
|
|
|
|
|
|
|
| 7 |
.
|
|
|
|
|
|
| 9 |
|
| 4 |
|
|
|
|
|
|
|
|
|
|
|
| 8 |
.00
|
|
| 8.0
| 1 |
Sample Mean: |
| 7.9A |
Sample Std.: |
|
|
| 7.78 |
Sample Size: |
|
|
| 7.88 |
| 7.8
|
|
|
| 5 |
Label Weight (oz): |
8.00
7.94
| Alpha: |
0.001 |
| 8.02 |
7.94
| Comparison Data |
|
|
| 7.81 |
7.78
| Critical Value: z = |
|
| 7.84 |
Test Statistic: z = |
| 7.79 |
7.88
| P-Value = |
| 7.8
| B |
| 7.9C |
7.81
8.00
| 8.0
| 3 |
8.01
8.00
| 7.8D |
| 7.80 |
| 7.87 |
| 7.55 |
8.00
7.81
7.84
|
| 7.7
|
|
|
|
|
|
| 6 |
| 7.92 |
8.00
8.01
| 7.61 |
7.76
7.88
| 7.77 |
7.94
8.00
7.78
Mercury Motels
| MERCURY MOTELS |
| Hotel |
Phone |
Online |
1 8 6
2 7 6
3
|
|
|
|
|
|
|
|
| 11 |
9
4 7 11
5 11 9
6 6 7
7 7
|
|
|
|
|
|
|
| 10 |
8 A 8
9
|
|
| 12 |
| 15 |
10
|
| 14 |
10
11
|
|
|
|
| 13 |
6
12
|
|
| 16 |
9
13 9 C
14 7 10
15 11 4
16 11 4
|
| 17 |
13 7
| 18 |
11 5
| 19 |
10 10
| 20 |
9 D
| 21 |
B 7
| 22 |
9 6
| 23 |
11 9
| 24 |
13 6
| 25 |
17 8
| 26 |
16 12
| 27 |
11 5
| 28 |
10 13
| 29 |
8 5
| 30 |
10 7
Excel
Stat Pack
2
Excel Stat Pack 2
Golden Food Company
Hypothesis Testing:
1
Sample Z-Test
The Facts
The law firm Wi, Cheatem & Howe has hired you as a consultant regarding a potential “slack fill” case involving the Golden Food Company. “Slack fill” cases concern consumer products being sold under the stated label weight/volume.
Wi, Cheatem & Howe received a tip from a supervisor working at Golden’s Down River plant who claimed the plant manager purposely and routinely under-fills cups of Matcha Whipped Spreads that have a stated label weight of 8 ounces. In this way, the tipster claims, the company saves money and the plant manager pads her bonus.
Your assistant collected samples. Analyze the data based on the company’s packaging and the tipster’s claim.
Steps:
1) Pull up Golden Food Company data. Swap out the letters in
the highlighted cells with your red id #s as you did in Stat
Pack 1. For the East Hopkins data Click
fx:
2) In Cell G9 select
AVERAGE, and
input A7:A
4
6 in the first
dialogue box and then click OK.
3) In Cell G10: input STDEV (It may be STDEV.S), using A7:A46.
4) In Cell G11: input COUNT, using A7:A46.
5) In Cell G18: input NORMSINV, using G14 in the dialogue box.
6) In Cell G19 Type: =(G9-G13)/(G10/SQRT(G11)).
7) In Cell G21: click
fx, select NORMSDIST and input G19 in the
dialogue box (If there is a CUMULATIVE box, input 1).
1
A Word About P-Values
The p-value is the exact probability of obtaining a particular calculated value or higher/lower, assuming all test assumptions are true. Being a probability, a p-value can be compared to alpha (another probability).
If p-value < alpha: Reject
If P-value > alpha: Fail to Reject
SEE LAST PAGE: SUMMARY POSITION
Responses must be typed.
State your test decision, basis*, and recommendation based on the analysis of your results.
*”Basis” is the reason on which you’re basing your Test Decision.
Your statements can and should be concise, clear, and in your own words!
Feel free to move headings for formatting reasons.
2
MERCURY MOTELS
Hypothesis Testing: 2 Sample T-Test
The Facts
Mercury Motels operates a chain of economy priced motels. As Director of Operations [DOPS] you collected data concerning the number of complaints regarding the reservation process, dividing the data into two groups: complaints stemming from reservations made over the phone and complaints stemming from their online proprietary e-bookings software.
You want to determine whether there is a significant difference in the number of complaints based upon these two methods, however, you do not believe one method is superior/inferior.
Steps:
1) Pull up the MERCURY MOTELS data.
2) Click on the DATA TAB and then select DATA ANAYLSIS.
3) Select: T-Test: Two Sample Assuming Unequal Variances.
4) Input the following:
Variable 1 Range: B5:B35
Variable 2 Range: C5:C35
Hypothesized Mean Difference: 0 (zero).
Select Labels
Alpha: .01
Output Range: E6.
SEE LAST PAGE: SUMMARY POSITION*
*For “DOPS Position” assume as Director of Operations you are reporting to the CEO of Mercury Motels.
Responses must be typed.
Test Decision and DOPS Position should be concise, clear and in your own words!
CLASS SURVEY DATA
1.
T-test: 2 Independent Samples Assuming Unequal Variances
From the Class Survey File, using the data from the Female, Male Data page —
A. If your section meets once-a-week:
a. Test Happy with Major for females versus males
b. Set alpha at, see “*” below
c. Set Output Option to New Worksheet Ply
B. If your section meets twice-a-week:
a. Test College Stress Level for females versus males
b. Set alpha at, see “*” below
c. Set Output Option to New Worksheet Ply
2. T-Test: 2 Dependent Samples (Paired)Test
All Sections: From the Class Survey File, Copy & Paste the Last Semester Rating** and This Semester Rating** data (Columns M & R) to
a new page –
1) Click on the DATA TAB and then select DATA ANAYLSIS.
2) Select: t-Test: Paired Two Sample for Means
3) Inputs: Select Labels (Column Headings), for Alpha see “*”
below, and for Output Range select New Worksheet play
*Alpha → If your class size is < 100 → Alpha = .01
→ If your class size is > 100 → Alpha = .001
**Semester Rating statements from the survey:
Column M: LAST SEMSTER went incredibly well.
Column R: I expect THIS SEMESTER to turn out extremely well.
Scale: 1 = Strongly Disagree, 5 = Strongly Agree
For ALL Analysis
:
• Turn in ONLY the OUTPUT tables. Copy, Paste, Arrange and Identify all output tables onto 1 or 2 pages. Do NOT turn in any raw (given) data.
SEE SUMMARY POSITION page
• Responses must be typed.
• Responses should be concise, clear, and in your own words!
• Type your name where directed and sign.
• Attach the Summary page to the front of your work packet.
• Summary Position can NOT be longer than 1 page.
4
SUMMARY POSITION
Golden Food Company
1. Slack Fill Test Decision & Basis:
2. Recommendation for Client:
Mercury Motel
1. Reservation Process Complaints Test Decision & Basis:
2. DOPS Position:
Student Survey Data (2 Sample Independent t-test)
1. Test Decision & Basis
2. Interpretation of Test:
Semester Ratings (2 Sample Dependent [Paired] t-Test)
1. Test Decision & Basis:
2. Interpretation of Test:
The above is solely of my work and in my words.
Last Name, First Name (Type):
_________________________________________________________________ ________________________
Signature (Pen) Date
