Kaplan GB513: Business Analytics Unit 3: Assignment (2016)

| August 31, 2017

estion
Unit 3 [GB513: Business Analytics]
Unit 3: Assignment
This Assignment requires you to use Excel only in Question 3. Follow all instructions carefully.
Questions 1, 2, and 3 have specific requirements.
Make sure to use the Unit 3 Assignment template located in Doc Sharing to submit your answers.
Question 1
Suppose a study reports that the average price for a gallon of self-serve regular unleaded gasoline is
$3.16. You believe that the figure is higher in your area of the country. You decide to test this claim
for your part of the United States by randomly calling gasoline stations. Your random survey of 25
stations produces the following prices (all in dollars). Assume gasoline prices for a region are
normally distributed.
Did the data you obtained provide enough evidence to reject the claim? Use a 1% level of
significance.
Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following
your calculations, clearly state the conclusion in the same manner (do not simply say “accept/reject
null”) and explain how you arrived at this conclusion (based on which metrics).
3.27
3.3
3.16
3.15
3.11
3.05
3.08
3.12
3.13
3.14
3.16
3.19
Unit 3 [GB513: Business Analytics]
3.27
3.14
3.14
3.2
3.3
3.09
3.05
3.07
3.37
3.34
3.35
3.35
3.1
Question 2
Where do CFOs get their money news? According to Robert Half International, 47% get their money
news from newspapers, 15% get it from communication/colleagues, 12% get it from television, 11%
from the Internet, 9% from magazines, 5% from radio, and 1% do not know. Suppose a researcher
wants to test these results. She randomly samples 67 CFOs and finds that 40 of them get their
money news from newspapers. Does the test show enough evidence to reject the findings of Robert
Half International? Use a = .05.
Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following
your calculations, clearly state the conclusion in the same manner (do not simply say “accept/reject
null”) and explain how you arrived at this conclusion (based on which metrics).
Question 3
To answer this question, use the Data Analysis Toolpack in Excel and select “t-Test: Two-Sample
Assuming Equal Variances” from the list of available tools. Conduct a hypothesis test using this tool.
Explain your answer (how you decided if men spend more or not) and include the output table.
Some studies have shown that in the United States, men spend more than women buying gifts and
cards on Valentine’s Day. Suppose a researcher wants to test this hypothesis by randomly sampling
Unit 3 [GB513: Business Analytics]
9 men and 10 women with comparable demographic characteristics from various large cities across
the United States to be in a study. Each study participant is asked to keep a log beginning 1 month
before Valentine’s Day and record all purchases made for Valentine’s Day during that 1-month
period. The resulting data are shown below. Use these data and a 1% level of significance to test to
determine if, on average, men actually do spend significantly more than women on Valentine’s Day.
Assume that such spending is normally distributed in the population and that the population variances
are equal.
Make sure you clearly state both the null and the alternative hypotheses in full sentences. Include the
output table; then, clearly state the conclusion in the same manner (do not simply say “accept/reject
null”) and explain how you arrived at this conclusion (based on which metrics).
Men Women
107.48 125.98
143.61 45.53
90.19 96.35
125.53 80.62
70.79 46.37
83 84.34
129.63 75.21
154.22 68.48
93.8 65.84
——- 126.11
Directions for submitting your Assignment
Make sure to use the Unit 3 Assignment template from Doc Sharing when you turn in your answers.
Submit your Assignment to the Unit 3 Dropbox.

Get a 30 % discount on an order above $ 5
Use the following coupon code:
CHRISTMAS
Order your essay today and save 30% with the discount code: CHRISTMASOrder Now
Positive SSL