question archive Task Instructions · The task should be done individually
Task Instructions · The task should be done individually
Subject:MathPrice: Bought3
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 |
Business 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. |
