Reference no: EM13904934
Read the scenario and analyze the given data by answering the following questions. All calculations must be conducted using statistical software MS Excel. You must provide, as a part of your response to the calculation questions, the session output of the statistical software, screen shots of the MS Excel formula/results. Answer the questions directly on this MS Word document. Grading of this assignment will follow the grading rubric provided in the course syllabus.
Scenario: In the early 1990s, research at the Ohio State University studied consumer ratings of six fast-food restaurants: Borden Burger, Hardee's, Burger King, McDonald's, Wendy's, and White Castle. Each of the 406 randomly selected individuals gave each restaurant a rating of 1, 2, 3, 4, 5, or 6 on the basis of taste, and then ranked the restaurants from 1 through 6 on the basis of overall preference. In each case, 1 is the best rating and 6 is the worst rating. The data collected, used the same scale and included taste (MeanTaste), convenience (MeanConv), familiarity (MeanFam), price (MeanPrice) and preference (MeanPref). The requirement is to determine if there is a relationship between convenience and price, and if predictions of convenience can be made based on price. The mean ratings given by the 406 individuals are given in the following table:
Table 1. Output of Fast-Food Restaurant Ratings
|
Restaurant
|
MeanTaste
|
MeanConv
|
MeanFam
|
MeanPrice
|
MeanPref
|
|
BordenBurger
|
3.5659
|
2.7005
|
2.5282
|
2.9372
|
4.2552
|
|
Hardee's
|
3.3290
|
3.3483
|
2.7345
|
2.7513
|
4.0911
|
|
Burger King
|
2.4231
|
2.7377
|
2.3368
|
3.0761
|
3.0052
|
|
McDonald's
|
2.0895
|
1.9380
|
1.4619
|
2.4884
|
2.2429
|
|
Wendy's
|
1.9661
|
2.8920
|
2.3376
|
4.0814
|
2.5351
|
|
White Castle
|
3.8061
|
3.7242
|
2.6515
|
1.7080
|
4.7812
|
1. Describe the data and variables.
2. Conduct appropriate descriptive statistical analysis, using selected software, for the given data (include appropriate graphs, if possible). Ensure you include screen shots of the MS Excel analysis.
3. Describe the appropriate method of analysis and the reason for its appropriateness.
4. Conduct appropriate statistical analysis, using selected software. Ensure you include the session output from screen shots of the MS Excel analysis, .
5. Provide your supported decision, based on any hypothesis tests, and your recommendations, where appropriate.
|
Why most researchers consider schizophrenia brain disorder
: Why do most researchers consider schizophrenia a brain disorder? What evidence suggests that schizophrenia could begin in the womb
|
|
Does your state impose the death penalty?
: Does your state impose the death penalty?
|
|
Golf challenge corp. is a retail sports store carrying
: Golf Challenge Corp. is a retail sports store carrying golf apparel and equipment.
|
|
Write electric and magnetic fields for monochromatic plane
: Write the (real) electric and magnetic fields for a monochromatic plane wave of amplitude Eo, frequency ω, and phase angle zero that is traveling in the negative x direction and polarized in the z-direction.
|
|
Conduct appropriate descriptive statistical analysis
: Conduct appropriate descriptive statistical analysis, using selected software, for the given data (include appropriate graphs, if possible). Ensure you include screen shots of the MS Excel analysis.
|
|
Authorized share capital
: A limited has an authorized share capital of 200,000 shares of Kshs. 1 each out of which only 150,000 shares have been issued. Although the firm requested the shareholders to pay 80 cents per share, they were able to pay 50 cents per share.
|
|
Prepare and lodge the tax return to avoid penalties
: An individual who is not an existing client approaches you in early November stating that the income tax return for the financial year has not been prepared or lodged.
|
|
Can anyone think of company that act as industry leader
: Has there ever been a time when the external benchmarking was not beneficial? Why or why not? How does the financial institution determine if the benchmarking is needed? Can anyone think of a company that would act as an industry leader? Why
|
|
Determine the value of the b-field in tesla
: When Thomson experimented with his apparatus, he noticed that in one run, the electron beam dropped 1.35 cm. when it emerged from the parallel plate region (where the electric and magnetic fields were present). If L = 5 cm, E = 1000 volts/meter, d..
|