Reference no: EM131150408
HYPOTHESIS TESTING
This Assignment requires you to use Excel only in Question 3. Follow all instructions carefully. Questions 1, 2, and 3 have specific requirements.
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.54
3.25
3.05
3.11
3.13
3.15
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 76 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 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
|
59.32
|
90.19
|
96.35
|
125.53
|
80.62
|
70.79
|
77.60
|
83
|
84.34
|
129.63
|
75.21
|
154.22
|
68.48
|
93.8
|
65.84
|
111.25
|
126.11
|
78.6
|
82.54
|
89.35
|
123.50
|
Perform exploratory data analysis on all variables in set
: Perform exploratory data analysis on all variables in the data set. Realizing that you have six groups, be sure that your exploratory analysis is divided by groups.
|
How would you set up the hypothesis test
: How would you explain to management the significance of this test? How would you set up the hypothesis test? State what the null and alternative hypothesis would be, what kind of a test you would use.
|
Describe the region of the hospital
: Describe the region of the hospital where you work or a hospital located near your home. Use the data from the Dartmouth Atlas, Commonwealth Fund, and one other resource to support your conclusions about your hospital and region
|
Relationships between cognitive and conceptual development
: Explain which theories of conceptual development are present in the case study. Provide an example to support your thinking. Examine the relationships between cognitive and conceptual development that are present in the case study.
|
Provide enough evidence to reject the claim
: Suppose a study reports that the average price for a gallon of self-serve regular unleaded gasoline is $3.16. Did the data you obtained provide enough evidence to reject the claim? Use a 1% level of significance.
|
Analyze challenges faced by the health care organization
: Analyze the role each stakeholder has in the strategies to address the challenges of the health care organization in the case study. Analyze what programs and services are available to address the challenges.
|
How customer demands have impacted scm solutions
: Describe B2B and middleware processes (and supply chain performance monitoring tools) used by this organization in e-commerce. Explain how this organization's business-to-business (B2B) solutions differ from business-to-consumer (B2C) solutions.
|
Describe and apply concept and logic of elementary statistic
: Describe and apply the concepts and logic of elementary statistics. Conduct statistical analysis in SPSS (Statistical Package for the Social Sciences). Compare and contrast different types of data and the statistics that can be used to analyze them.
|
Inventory analysis and optimizing staffing
: Assume that you are a health care administrator in a hospital, and you are responsible for staffing levels. Suggest an approach to staffing for 24/7 coverage that optimizes patient care, minimizes cost, and produces the highest level of employee s..
|