Data Analysis Report

2869 words - 12 pages

Data analysis report
Divine Elegance: A Restaurant
Table of Contents
Introduction 2
Preliminary Analysis 2
Data Screening and Hypothesis Testing 2
1. How much are potential patrons willing to pay for the entrées? Is the $18 amount from the forecasting model correct? 2
2. Can Michael expect all patrons to spend an average of $200 a month on food? 4
3. Which zip code area(s) provide the best location for the restaurant? Does the expected average monthly spend differ between potential patrons residing in different zip codes 6
4. Does the likelihood to patronize the restaurant different between people with different income levels? 8
5.How elegant should the décor be? Would ...view middle of the document...

Lastly, the methods to promote the restaurant will be given. In order to give the decision to Michael, the report will use different statistical methods to explore the data collected from survey and help Michael to make decisions. After the data analysis, the conclusion and recommendation will be given to Michael.

Preliminary Analysis
The frequencies for categorical variables and descriptive statistics for variables are shows in appendix A.
According to the frequencies for categorical variables, we find that all the people in the survey went to this type of restaurant at least once every two week with moderate likelihood to patronlize this restaurant. In the radio section, almost all the customers listen to the radio and rock music are they favorite. In the TV section, the customers like 10:00 pm news. Also they like local news section in the newspaper. For the operating characteristics, they somewhat prefer the waterfront, like simple décor, prefer the restaurant not too fat from home. And not prefer large variety of Entrees and unusual entrees. In the consumers’ characteristics section, Almost 60% customers have bachelor’s degree and more than half are married with income range from $50,000 to $74,999.
The preliminary analysis give the general idea from the customers, however, the deeper statistical test need to conduct in order to get the deeper understanding with the customers.

Data Screening and Hypothesis Testing
1. How much are potential patrons willing to pay for the entrées? Is the $18 amount from the forecasting model correct?
The data present very well in this question, we assume that the populations are normally distributed.

1. State the null and alternate hypotheses
H0: μ=18
Ha: μ≠18

2. Choose an appropriate statistical technique to test the hypothesis
One sample t-test is used to test the hypothesis because the variable is independent and the one sample t-test compares the mean score of a sample to a known value.

3. Provide a summary of the nature (characteristics) of the test selected
Reject null hypothesis is p value less than 0.05.

4. Perform the appropriate test using SPSS

5. Report the results (including test statistic and p-value)
The t value is 1.567 and the p-value is 0.118

6. Include appropriate graphical representation of the results (if appropriate)

7. Provide a suitable description for the graphical output
The distribution is skewed to the right. The average amount of patrons willing to pay is $18.8353.

8. Provide a statistical interpretation
P value is 0.118 is greater than the critical value of 0.05. Do not reject null hypothesis. There is sufficient evidence to shows that the potential patron willing to pay for the entrees is $18.

9. Provide a non-statistical interpretation (in layman’s terms)
The potential patrons willing to pay $18 for the entrée, the best price strategy for entrée should be greater than $18.
2. Can Michael expect all patrons to spend an...

Other Essays Like Data Analysis Report

2015 Market Research Report on Global Liquid Chlorine Industry

571 words - 3 pages forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Liquid Chlorine leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers Liquid Chlorine upstream raw

World Corrugated Container Board Market by Specification and Segment Status 2020

632 words - 3 pages , capacity, market position, and company Contact information, etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these Corrugated Container Board markets are also included. For technical data and manufacturing plants analysis, the report analyzes Corrugated Container Board leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status

International Electroplated Diamond Wire Market Technology Review & Forecasts to 2020

599 words - 3 pages , capacity, market position, and company Contact information, etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Electroplated Diamond Wire Market leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw

2015 Market Research Report on Global Infrared Night-Vision Scope Industry

645 words - 3 pages information, etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Infrared Night-vision Scope leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report

Global Olanzapine Industry Report 2015

651 words - 3 pages company contact information, etc. 2016-2021 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Olanzapine leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D Status, technology sources, and raw materials sources. This report also presents product

Global and China Heptyl Ketone Industry 2014 Market Research Report

1051 words - 5 pages Global and China Heptyl Ketone Industry 2014 Market Research Report The report firstly introduced Heptyl Ketone basic information included Heptyl Ketone definition classification application industry chain structure industry overview; international market analysis, China domestic market analysis, Macroeconomic environment and economic situation analysis and influence, Heptyl Ketone industry policy and plan, Heptyl Ketone product

2015 Market Research Report on Global Acetone Industry

1433 words - 6 pages , production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Acetone leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers Acetone upstream raw materials, equipment, downstream

Firstly Introduced Crosslinked Polyethylene(Xlps)

1010 words - 5 pages Global and China Crosslinked polyethylene (XLPS) Industry 2013 Market Research Report The report firstly introduced Crosslinked polyethylene(XLPS) basic information included definition classification application industry chain structure industry overview; international market analysis, Global and China domestic market analysis, Macroeconomic environment and economic situation analysis and influence, Crosslinked polyethylene(XLPS) Industry

New Research on Melt Pump Industry 2013 at Researchmoz

957 words - 4 pages Global and China Melt Pump Industry 2013 Market Research Report The report firstly introduced Melt Pump basic information included definition classification application industry chain structure industry overview; international market analysis, Global and China domestic market analysis, Macroeconomic environment and economic situation analysis and influence, Melt Pump Industry policy and plan, Melt Pump product specification, manufacturing

M-Phenylenediamine (Mpda) Industry 2013 Market Research Report

1014 words - 5 pages Global and China Alkyl Polyglycoside (APG) Industry 2013 Market Research Report The report firstly introduced Alkyl Polyglycoside(APG) basic information included definition classification application industry chain structure industry overview; international market analysis, Global and China domestic market analysis, Macroeconomic environment and economic situation analysis and influence, Alkyl Polyglycoside(APG) Industry policy and plan

Research | Global Food Mixing Machine Industry 2013

1001 words - 5 pages Global and China Food mixing machine Industry 2013 Market Research Report The report firstly introduced Food mixing machine basic information included definition classification application industry chain structure industry overview; international market analysis, Global and China domestic market analysis, Macroeconomic environment and economic situation analysis and influence, Food mixing machine Industry policy and plan, Food mixing machine

Related Papers

Global And Chinese Biomolecular Interaction Analysis Industry, Size, Share, Analysis, 2009 Forecast 2019

625 words - 3 pages Interaction Analysis listing their product specification, capacity, Production value, and market share etc.; The report further analyzes quantitatively 2009-2014 global and Chinas total market of Biomolecular Interaction Analysis by calculation of main economic parameters of each company; The breakdown data of Biomolecular Interaction Analysis market are presented by company, by country, and by application; The report also estimates 2014-2019

Global Crystalline Maltitol Industry Report 2015

599 words - 3 pages , etc. 2015-2020 forecast on capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Crystalline Maltitol leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers

Global And China Cloperastine Market 2014 Industry Analysis, Overview, Research And Development

1103 words - 5 pages export consumption etc data statistics, and then introduced Global and China Cloperastine 2009-2019 capacity production price cost profit production value gross margin etc information. And also listed Cloperastine upstream raw materials equipments and down stream clients survey analysis and Cloperastine marketing channels industry development trend and proposals. In the end, The report introduced Cloperastine new project SWOT analysis Investment

2015 Market Research Report On Global Tequila Industry

632 words - 3 pages capacity, production, cost, price, profit, production value, and gross margin for these markets are also included. For technical data and manufacturing plants analysis, the report analyzes Tequila leading suppliers on capacity, commercial production date, manufacturing plants distribution, R&D status, technology sources, and raw materials sources. For industry chain analysis, the report covers Tequila upstream raw materials, equipment