APPLIED MANAGEMENT STATISTICS

 

 

Task Instructions
• All the figures and tables in the reports should be organized in Excel and should have a proper title and a number.
• You should choose the appropriate statistical method to answer each task problem.
• The interpretations of each analysis, table and figure should be written detailly.

The data set is a survey of restaurants in Wisconsin, Canada and includes 13 variables defined as follows:

Variable Label
Outlook Business Outlook (1: Hopeless, 2: Very poor, 3: Poor, 4: Good, 5: Very good,
6: Excellent)
Sales Gross Sales (1000 pounds)
New cap New capital invested (1000 pounds)
Value Estimated market value of business (1000 pounds)
Cost good Cost of goods sold as % of sales
Wages Wages as % of sales
Advert Advertising as % of sales
Type Type of Outlet (1: Take away, 2: Cafe, 3: Restaurant)
Owner Type of ownership (1: Sale owner, 2: Partnership, 3: Company)
Full Number of full-time employees
Part Number of part-time employees
Size Size of establishment in FTE equivalent

Task Brief:
1) Compare the three types of food outlet: restaurants, cafes and takeaways in terms of
 the percentage of each type of outlet,
 their business outlook
 the types of ownership
by using proper graphical representation.

2) Compare the average gross sales and the estimated market value of each type of outlet. Organize a descriptive table to show mean, standard deviation, minimum, maximum and interquartile range of gross sales and estimated market value for each food outlet and interpret the results.

3) Analyze the distribution of following variables by using a histogram and interpret it.
 Wages as % of sales for all outlets together; wages as % of sales for each type of outlet
 Advertising as % of sales for all outlets together; advertising as % of sales for each type of outlet

4) Find the Pearson’s correlation coefficient between the gross sales and other continuous variables. For the most significant association found, draw the scatter plot, interpret the finding.

Formalities:
• Wordcount: Between 1000-1500 words
• Cover, Table of Contents, References and Appendix are excluded of the total wordcount.
• Font: Arial 12,5 pts.
• Text alignment: Justified.
• The in-text References and the Bibliography have to be in Harvard’s citation style.

It assesses the following outcomes:
• Outcome 1: Choosing proper graph(s) to visualize data according to its structure.
• Outcome 2: Exploratory data analysis by using descriptive statistics and tables.
• Outcome 3: Interpretation of the important information hidden in the data.
• Outcome 4: When to use which descriptive measures.

 

 

The post APPLIED MANAGEMENT STATISTICS first appeared on COMPLIANT PAPERS.