(
BCO127
APPLIED
MANAGEMENT
STATISTICS
Final Task
brief
&
rubrics
)
Task Instructions
· The task should be done individually.
· The task should be submitted in pdf format and the excel outputs should be in the Appendix.
· 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
Outlook
Sales
Gross Sales (1000 pounds)
Newcap
New capital invested (1000 pounds)
Value
Estimated market value of business (1000 pounds)
Costgood
Cost of goods sold as % of sales
Wages
Wages as % of sales
Advert
Advertising as % of sales
Type
Type of Outlet
Owner
Type of ownership
Full
Number of full-time employees
Part
Number of part-time employees
Size
Size of establishment in FTE equivalent
Task Brief:
Your directors would also like to know how the gross sales affect the market value of food outlet they might open.
1) Draw the scatter plot between market value and gross sales. Add the “type of outlet” variable as an indicator to the scatter plot. Interpret the graph.
2) Find the regression equation between the market value and gross sales for each type of outlet. Write the equation, interpret coefficients, goodness of fit and the significance of the model (Use the Data Analysis Toolbox in Excel).
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.
Submission: Week 13 – Via Moodle (Turnitin). Until 9th May 2021 at 23:59pm.
Weight: This task is a 40% of your total grade for this subject.
It assesses the following learning outcomes:
· Outcome 1: Analyzing and interpreting the linear relationship between two quantitative variables.
· Outcome 2: Constructing regression models between two numerical variables and their interpretations.
· Outcome 3: Finding and interpreting the coefficient of correlation.
Rubrics
Exceptional 90-100
Good 80-89
Fair 70-79
Marginal fail 60-69
Knowledge & Understanding (20%)
Student demonstrates excellent understanding of key concepts and uses vocabulary in an entirely appropriate manner.
Student demonstrates good understanding of the task and mentions some relevant concepts and demonstrates use of the
relevant vocabulary.
Student understands the task and provides minimum theory and/or some use of vocabulary.
Student understands the task and attempts to answer the question but does not mention key concepts or uses minimum amount of relevant
vocabulary.
Application (30%)
Student applies fully relevant knowledge from the topics delivered in class.
Student applies mostly relevant knowledge from the topics delivered in class.
Student applies some relevant knowledge from the topics delivered in class. Misunderstanding
may be evident.
Student applies little relevant knowledge from the topics delivered in class.
Misunderstands are evident.
Critical Thinking (30%)
Student critically assesses in excellent ways, drawing outstanding conclusions from relevant authors.
Student critically assesses in good ways, drawing conclusions from relevant authors and references.
Student provides some insights but stays on the surface of the topic.
References may not be relevant.
Student makes little or none critical thinking insights, does not quote appropriate authors, and does not
provide valid sources.
Communication (20%)
Student communicates their ideas extremely clearly and concisely, respecting word count, grammar and spellcheck
Student communicates their ideas clearly and concisely, respecting word count, grammar and spellcheck
Student communicates their ideas with some clarity and concision. It may be slightly over or under the wordcount limit. Some misspelling errors
may be evident.
Student communicates their ideas in a somewhat unclear and unconcise way. Does not reach or does exceed wordcount excessively and misspelling errors are
evident.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more