Excel project help needed

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:A46 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