There are no exact answers or perfect solutions to case problems. Indeed, each recommended solution and justification can and is usually different comparatively amongst a group of respondents. The solution must fit the case and must be vigorously supported. The problem statement, analysis, selected solution, and especially the justification of the selected solution, are all critical elements In the case method. There are no short cuts to case presentations but a formalized methodology that enables the case presenter the optimal way to solve the case problem.

Your responses must be comprehensives, using terminology and concepts presented in the primary textbook as well as supplementary resources. Answer all questions presented in the Case. Write in complete sentences and use good grammar, double-spacing, Times New Roman 12 point font, with one inch margins. Be sure to cite your resources and provide the references using APA format. Remember to reference all work cited or quoted by the text authors.

You must read and follow the Graduate Case Study Format file found in the course resources area.

Complete and submit case studies 8.3, delivery Times at SnowPea Restaurant (Pg 397).

Activity Outcomes
1. Implement quantitative assessment/analyses methods using Microsoft Excel Spreadsheets.
2. Recognizing the limitations and assumptions of the data or statistical technique .
3. Interpret your conclusions to identify settings in which models can be used effectively and apply modeling concept practical situations.
4. Demonstrate ethical behavior in regard to information and information technology.

Activity: Exercise Problems

Activity Description Exercise Problems

For this assignment complete the exercises below. Show enough of your work so that your instructor can follow your logic.

Q1# The file P09_01.xlsx contains a random sample of 100 lightbulb lifetimes. The company that produces these lightbulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours.

a. Identify the null and alternative hypotheses for this situation.
b. Can this lightbulb manufacturer claim that its lightbulbs typically last more than 1000 hours at the 5% significance level? What about at the 1% significance level? Explain your answers.

Q2# A manufacturer is interested in determining whether it can claim that the boxes of detergent it sells contain, average, more than 500 grams of detergent. The firm selects a random sample of 100 boxes and records the amount of detergent (in grams) in each box. The data are provided in the file P09_02.xlsx.
a. Identify the null and alternative hypotheses for this situation.
b. Is there statistical support for the manufacturer's claim? Explain.

Q3# In the past, 60% of all undergraduate students enrolled at State University earned their degrees within four years of matriculation. A random sample of 95 students from the class that matriculated in the fall of 2008 was recently selected to test whether there has been a change in the proportion of students who graduate within four years. Administrators found that 40 of these 95 students graduated in the spring of 2012 (1.e., four academic years after matriculation).

a. Given the sample outcome, find a 95% confidence interval for the relevant population proportion. Does this interval estimate suggest that there has been a change in the proportion of students who graduate within four years? Why or why not?

b. Suppose now that State University administrators want to test the claim made by faculty that the proportion of students who graduate within four years at State University has fallen below the historical value of 60% this year. Use this sample proportion to test their claim.

Report a p-value and interpret it.

Q4# A market research consultant hired by a leading softdrink company wants to determine the proportion of consumers who favor Its low-calorie drink over the leading competitor's low-calorie drink in a particular urban location. A random sample of 250 consumers from the market under investigation is provided In the file P08_18.xlsx.
a. Find a 95% confidence interval for the proportion of all consumers in this market who prefer this company's drink over the competitor's. What does this confidence interval tell us?
b. Does the confidence interval in part a support the claim made by one of the company's marketing managers that more than half of the consumers in this urban location favor its drink over the competitor's? Explain your answer.
c. Comment on the sample size used in this study. Specifically, is the sample unnecessarily large? Is it too small? Explain your reasoning.

Q5# The file P08_49.xisx contains data on 400 orders placed to ElecMart company over a period of several labs. For each order, the file lists the time of day, the type of credit card used, the region of the country where the customer resides, and others. (This is the same data set used in Example 3.4 of Chapter 3.) Use a chi-square test for Independence to see whether the following variables are independent. If the variables appear to be related, discuss the form of dependence you see.
a. Time and Region
b. Region and Buy Category
c. Gender and Card Type

Attachment:- Case.rar