MIS771 MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 1 of 10 MIS771 Descriptive Analytics and Visualisation Assignment Two Background This assessment task is an...

1 answer below »
MIS771 Descriptive Analytics and Visualisation


MIS771 MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 1 of 10 MIS771 Descriptive Analytics and Visualisation Assignment Two Background This assessment task is an individual assignment, which requires you to analyse a given data set, interpret and draw conclusions from your analysis, and then convey your findings in a written technical report to an expert in Business Analytics. Percentage of final grade 35% The Due Date and Time 11.59 PM Sunday 16th September 2018 AEST Submission instructions The assignment must be submitted by the due date electronically in CloudDeakin. When submitting electronically, you must check that you have submitted the work correctly by following the instructions provided in CloudDeakin. Please note that we will NOT accept any paper or email copies, or part of the assignment submitted after the deadline. No extensions will be considered unless a written request is submitted and negotiated with the Unit Chair before Thursday 13th September 2018, 5:00 PM. Please note that assignment extensions will only be considered if you attach your draft assignment with your request for an extension. You must keep a backup copy of every assignment you submit (that is, the work you have done to date) until the assignment has been marked. In the unlikely event that an assignment is misplaced, you will need to submit your backup copy. Work you submit will be checked by electronic or other means to detect collusion and/or plagiarism. When you submit an assignment through your CloudDeakin unit site, you will receive an email to your Deakin email address confirming that the assignment has been submitted. You should check that you can see your assignment in the Submissions view of the Assignment Dropbox folder after upload, and check for, and keep, the email receipt for the submission. MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 2 of 10 Penalties for late submission: The following marking penalties will apply if you submit an assessment task after the due date without an approved extension: 5% will be deducted from available marks for each day up to five days, and work that is submitted more than five days after the due date will not be marked. You will receive 0% for the task. 'Day' means calendar days or part thereof. The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the task after the due date. For more information about academic misconduct, special consideration, extensions, and assessment feedback, please refer to the document Your rights and responsibilities as a student in this Unit in the first folder next to the Unit Guide of the Resources area in the CloudDeakin unit site. The assignment uses the file stores.xlsx, which can be downloaded from CloudDeakin. Analysis of the data requires the use of techniques studied in Module 2. Assurance of Learning This assignment assesses the following Graduate Learning Outcomes and related Unit Learning Outcomes: Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO) GLO1: Discipline-specific knowledge and capabilities - appropriate to the level of study related to a discipline or profession. GLO3: Digital Literacy - Using technologies to find, use and disseminate information GLO5: Problem Solving - creating solutions to authentic (real-world and ill-defined) problems. ULO 1: Apply quantitative reasoning skills to solve complex problems. ULO 2: Use contemporary data analysis and visualisation tools and recognise the limitation of such tools. Feedback before submission You can seek assistance from the teaching staff to ascertain whether the assignment conforms to submission guidelines. Feedback after submission An overall mark together with suggested solutions will be released via CloudDeakin, usually within 15 working days. You are expected to refer and compare your answers to the suggested solutions to understand any areas of improvement. MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 3 of 10 Case Study (Background to Furphy) Furphy is one of Australia's leading supermarket chains. There are 700 stores in the chain. Originating from a family based chain of general stores, Furphy now has stores all over Australia, with the first one being established 27 years ago. Regarding operation, individual store management has wide-ranging powers about the day-to-day operations of their stores. However, Furphy’s strategic planning and direction take place in the company Head Office in Melbourne. In 2016, Furphy Head Office asked all store managers to add an online channel to their stores to enable customers, in their suburbs, to make their purchase online. Despite their successful operations and solid financial turnovers in the last two years, Furphy is forecasting a shift in the business climate within the next five years. This is a result of ever-increasing competition in the grocery supermarket sector. Now more than ever, Furphy management feels the need to ensure a good understanding of their business performance. The Furphy Head Office is slightly confused about the lack of enthusiasm of store managers to open their online sales channel given that Furphy Head office has invested heavily on a digital platform and distribution partnership with a transport company. Also, they are planning to put in place a formal procedure to forecast their Sales. Subsequently, Furphy has approached BEAUTIFUL-DATA (a market research company) and asked them to conduct a study to understand the characteristics of Furphy’s stores and their business performance. The Data For this study, BEAUTIFUL-DATA has collected two sets of Data: 1. The data related to stores were extracted from the Furphy’s datamarts. It is a random sample of 150 stores in the Furphy chain. A complete listing of variables, their definitions, and an explanation of their coding are provided in Working Sheet “Stores-Variable Description. 2. Time-series data is available on Working Sheet “Quarterly Sales”. Your Role as a BEAUTIFUL-DATA Data Analyst Intern You are a Master of Business Analytics student doing an internship at BEAUTIFUL-DATA. The research team manager (Todd Nash, with a PhD in Data Science and a Master Degree in Digital Marketing) has asked you to lead the data analysis process for the Furphy project and directly report the results to him. You and Todd just finished a meeting wherein he briefed you on the vital purpose of the project. Todd explained that a model should be built to estimate Furphy’s Sales. Therefore, the first goal is to identify key factors that influence Sales. The second goal is to understand the relationship between number of competitors and Sales. He is also interested in gaining insights into factors that influence Furphy stores to open online sales channels. The final goal is to construct a forecasting model, which forecast Furphy’s Sales in the upcoming four quarters. From these insights, Todd and consequently Furphy will be in an excellent position to develop plans for the next financial year. MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 4 of 10 Todd also allocated relevant research tasks and explained his expectations from your analysis in the meeting. Minutes of this meeting are available on the next page. Now, your job is to review and complete the allocated tasks as per this document. MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 5 of 10 BEAUTIFUL-DATA, 727 Collins St, Docklands VIC 3008 Phone: (+61 3 212 66 000) [email protected] Reference PH-102 Furphy Project Revised 06th August, 2018 Level Expert Analysis Meeting Chair Todd Nash Date 06th August 2018 Time 11:00 AM Location BEAUTIFUL-DATA F3.101 Topic Furphy Project – Analytics Details Meeting Purpose: Specifying and Allocating Data Analytics Tasks Discussion items: • Variable(s) description. • Modelling Sales. • Modelling the likelihood of opening an online channel. • Forecasting Sales in the upcoming four quarters. • Producing a technical report. Detailed Action Items Who: Graduate Intern What: 1. Provide an overall summary of the following two variables: 1.1. Sales 1.2. Online Sales Channel 2. Identify potential factors that may influence Sales: 2.1. An appropriate statistical technique could be used here to identify a list of possible factors. 2.2. Build a model (through a model building process) to estimate Sales. 2.3. Todd has done a regression analysis to predict sales using number of competitors and stores open on Sundays. He believes that the relationship between number of competitors and sales should be weaker for those stores that are open on Sundays. Your task here is to test Todd’s assumption by modelling the interaction between the predictors mentioned above and the target variable. Comment whether there is sufficient evidence that the interaction term makes a significant contribution to the model. 3. Finalise the model to predict the likelihood of opening an online sales channel: 3.1. Todd has already done an initial analysis for this task. Based on his analysis, Todd has narrowed down the key predictors of the likelihood of opening an online sales channel to “Manager’s Age, Experience and Gender”. Your task now is to continue his work and develop a predictive model to ascertain the MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 6 of 10 “likelihood of opening an online sales channel”. Todd is specifically interested in understanding the probability of stores which meet the following criteria to open an online sales channel: Those stores with managers, a) in their mid-thirties; b) with varying levels of Management Experience (i.e. 2-16 years?); c) and across both, male and female store managers. 3.2. Todd believes that the age, experience and the gender of the store manager may influence the decision to open an online sales channel. Therefore, it is essential for Furphy to know whether effort and money should be put into recruiting tech-savvy young managers. Accordingly, your job is to visualise the predicted probability of opening online sales channels with the
unifolks_636726852730520403_121411_1.xlsx unifolks_636726852730520403_121411_2.pdf
Answered Same DaySep 16, 2020MIS771Deakin University

Answer To: MIS771 MIS771 - Descriptive Analytics and Data Visualisation Trimester 2, 2018 Page 1 of 10 MIS771...

Pooja answered on Sep 18 2020
138 Votes
Stores-Variable Description
    Supermart: National Survey of Stores
                
    Supermart is a fictitious company and meant to bear no resemblance to any existing organisation. All data are fictitious.
    The data in this database all relate to the end of the same financial year for all stores
    Random Sample of 150 Supermart stores Year Ended June 30, 2016
    Variable Name and Description:
    Sales $m:    Total Sales revenue for each store for the financial year. $ million.
    Wages $m:    Total Wage and salary bill for the financial year. $ million.
    No. Staff:    The number of effective full-time staff employed on a weekly basis.
    Age (Yrs):    The number of full years of operation of the store.
    GrossProfit:    Gross Profit for each store for the financial year. $ million.
    Adv.$'000:    Advertising and promotional expenses for the financial year, $'000
    Competitors:    The number of competing stores in the consumer catchment area
    HrsTrading:    The total number of hours open for trading per week
    Sundays:    1=Open on Sundays; 0=Close on Sunday
    Mng-Gender:    1=Male store manager; 0=Female store manager
    Mng-Age:    Age of the store manager, years
    Mng-Exp:    No. of years of experience in some form of junior/senior management at Supermart
    Mng-Train:    No. of management training courses taken while employed at Supermart
    Union%:    The proportion of the staff at the store which belongs to a union.
    Car Spaces:    The number of parking spaces available to the store.
    Online Channel    1=Online Channel, 0=No Online Channel
    Basket:2016    Cost ($) of the basket of food items in each store at 1 June 2016
    Basket:2017    Cost ($) of the basket of food items in each store at 1 June 2017
    %Change    Annual increase of the cost of the basket of food items in each store (Yt+1-Yt)/Yt
Stores_Data
    Store No.    Sales $m    Wages $m    No. Staff    Age (Yrs)    GrossProfit $m    Adv.$'000    Competitors    HrsTrading    Sundays    Mng-Gender    Mng-Age    Mng-Exp    Mng-Train    Union%    CarSpaces    OnlineChannel    Basket:2016    Basket:2017    %ChangeBasket
    1    12.5    2.3    60    10    0.712    171    3    110    1    0    33    12    2    38    46    1    $171    $178    4%
    2    14.5    2.7    69    8    0.091    213    3    134    1    0    33    16    1    36    73    1    $168    $178    6%
    3    19.0    3.1    79    7    1.720    255    1    98    1    1    40    13    2    39    64    1    $180    $188    4%
    4    18.2    2.6    66    7    1.372    287    1    85    1    1    29    10    2    38    66    0    $173    $180    4%
    5    7.6    2.0    51    15    0.935    112    4    72    1    0    36    4    3    40    29    0    $166    $171    3%
    6    18.5    2.7    62    6    2.019    238    0    77    1    1    32    15    4    37    40    1    $183    $192    5%
    7    13.1    2.4    61    7    0.662    124    2    100    1    1    52    15    3    37    69    0    $182    $191    5%
    8    14.9    2.5    59    6    0.700    214    2    95    1    0    41    4    3    36    45    0    $173    $182    5%
    9    17.1    2.7    65    8    0.937    215    4    112    0    1    31    12    5    40    42    1    $183    $192    5%
    10    9.2    2.1    55    16    0.065    154    3    75    0    0    42    13    2    34    34    1    $158    $165    4%
    11    10.3    2.2    65    10    2.144    97    2    100    1    0    32    8    2    40    51    1    $174    $180    3%
    12    19.3    3.1    74    7    0.248    301    1    96    1    1    39    21    5    40    86    1    $174    $187    7%
    13    8.1    1.8    43    23    1.607    123    1    72    0    0    45    8    3    44    19    0    $163    $170    4%
    14    9.1    3.3    78    3    1.624    148    5    73    1    0    39    11    4    36    59    0    $168    $175    4%
    15    15.7    2.8    67    9    0.050    228    4    86    0    1    31    13    1    38    70    1    $173    $181    5%
    16    9.8    2.1    62    16    0.588    136    4    121    1    1    41    10    3    41    44    1    $159    $167    5%
    17    19.5    3.8    99    9    1.760    369    4    85    0    1    38    12    2    38    68    1    $163    $170    4%
    18    16.2    2.6    67    8    0.045    187    0    73    1    1    29    13    1    41    45    1    $182    $192    5%
    19    8.0    1.9    51    12    1.000    66    3    90    1    0    34    6    2    40    25    0    $178    $184    3%
    20    12.2    2.6    71    13    0.121    116    0    82    0    1    34    8    2    47    51    1    $185    $193    4%
    21    11.1    2.4    65    3    0.159    144    2    85    0    1    47    14    3    27    59    1    $168    $174    4%
    22    16.8    3.0    86    8    2.284    201    0    80    1    1    38    10    2    32    78    1    $183    $192    5%
    23    11.8    2.0    51    8    0.799    96    6    145    1    1    34    12    2    40    22    0    $181    $189    4%
    24    14.0    2.3    56    7    0.911    134    2    112    1    0    30    13    1    38    34    1    $178    $185    4%
    25    10.5    2.3    60    3    0.813    101    3    106    1    0    44    8    3    33    45    0    $170    $177    4%
    26    6.2    1.6    40    14    0.976    82    2    101    0    0    37    5    3    40    9    0    $163    $168    3%
    27    16.9    3.4    85    12    1.860    311    2    124    1    1    37    13    2    42    62    1    $164    $172    5%
    28    7.9    1.5    35    6    0.047    65    4    88    1    0    27    5    6    37    16    0    $180    $186    3%
    29    9.6    1.9    51    6    0.498    31    4    117    1    0    30    5    2    36    20    0    $179    $187    4%
    30    16.3    3.7    102    12    0.084    249    2    86    1    1    38    11    2    32    114    1    $170    $177    4%
    31    11.2    2.6    70    14    0.048    197    4    72    1    1    35    11    3    42    56    0    $166    $172    4%
    32    13.1    2.5    61    7    0.960    213    2    101    1    1    30    10    5    39    43    1    $168    $173    3%
    33    8.0    1.8    44    3    1.180    69    2    72    0    0    34    6    2    47    20    0    $178    $183    3%
    34    16.1    3.9    98    3    0.974    201    1    91    1    1    37    6    3    32    106    0    $186    $194    4%
    35    10.4    2.0    53    4    1.315    69    1    78    1    1    35    9    2    47    25    0    $181    $189    4%
    36    7.4    1.8    44    12    0.974    117    3    96    0    0    33    6    2    40    22    1    $165    $170    3%
    37    10.5    2.3    58    15    0.167    81    1    120    0    0    39    10    2    47    35    0    $181    $188    4%
    38    12.0    2.3    60    5    0.937    211    3    112    1    0    59    15    4    37    39    0    $166    $171    3%
    39    14.5    2.4    54    9    0.046    151    0    72    1    1    30    13    5    39    26    0    $201    $204    1%
    40    5.9    1.9    48    2    0.018    77    2    150    0    0    28    1    6    30    24    0    $157    $160    2%
    41    9.0    1.9    53    13    0.840    99    3    110    1    0    36    9    2    41    30    1    $171    $176    3%
    42    15.8    3.5    88    18    1.000    283    2    104    1    0    40    8    3    43    64    0    $167    $177    6%
    43    14.0    2.5    59    5    1.159    196    1    99    1    0    43    15    5    35    45    0    $176    $184    5%
    44    15.3    3.4    117    2    0.104    253    2    145    1    1    52    15    3    30    59    0    $163    $169    4%
    45    14.4    3.1    83    22    0.936    203    2    111    1    0    45    9    3    50    87    0    $173    $178    3%
    46    14.8    3.6    91    2    1.968    164    1    86    1    0    33    5    2    37    98    0    $183    $194    6%
    47    12.1    2.5    56    4    2.536    146    1    84    1    1    36    8    2    50    40    0    $173    $179    3%
    48    8.0    1.9    51    2    0.417    121    3    123    0    0    36    8    2    33    32    1    $161    $167    4%
    49    8.4    2.0    56    14    0.039    128    1    97    0    1    43    6    3    41    37    0    $165    $172    4%
    50    10.6    2.0    51    3    1.155    132    2    98    0    1    35    1    3    35    26    0    $173    $181    5%
    51    10.9    2.3    56    9    1.999    75    0    72    0    1    49    7    4    41    33    0    $182    $189    4%
    52    8.7    2.1    53    2    2.872    144    6    73    1    1    35    4    3    50    34    0    $165    $171    4%
    53    9.5    2.5    62    21    0.734    152    3    111    1    0    44    5    3    47    43    0    $164    $169    3%
    54    6.8    1.7    44    4    0.046    104    6    86    1    0    29    2    2    36    21    0    $164    $168    2%
    55    7.2    1.6    41    12    0.879    112    2    120    0    0    39    5    3    40    14    0    $162    $167    3%
    56    11.3    2.6    72    4    1.496    139    2    84    1    1    36    6    3    34    77    0    $177    $184    4%
    57    9.4    2.0    55    14    0.655    150    3    108    1    0    37    9    2    40    35    0    $163    $168    3%
    58    8.6    1.8    48    10    1.644    60    3    118    0    1    34    19    1    39    22    1    $172    $180    5%
    59    17.1    2.9    76    5    0.819    266    4    92    0    1    52    18    5    34    87    1    $178    $186    4%
    60    15.4    2.4    58    6    1.623    209    1    88    0    1    45    10    3    38    45    1    $179    $187    4%
    61    11.0    2.2    51    6    1.084    181    2    101    0    1    53    9    4    37    33    0    $164    $170    4%
    62    15.6    3.0    67    13    1.461    180    4    91    0    0    44    10    3    40    44    0    $181    $187    3%
    63    7.6    1.8    50    3    0.532    111    2    120    0    0    46    3    4    32    26    0    $164    $172    5%
    64    11.4    2.4    58    2    1.336    150    2    98    0    1    38    9    2    47    41    1    $177    $183    3%
    65    23.5    3.6    89    8    1.018    348    0    98    1    1    36    12    1    40    57    1    $184    $195    6%
    66    12.4    3.2    76    19    0.043    214    2    98    1    1    42    3    3    43    59    0    $160    $166    4%
    67    13.4    2.7    71    5    1.280    141    2    96    0    1    28    9    1    37    54    1    $180    $186    3%
    68    13.8    2.5    63    12    0.612    148    3    116    1    0    35    10    2    39    42    0    $178    $185    4%
    69    11.6    2.3    55    3    0.739    146    3    114    1    1    43    11    3    28    35    0    $170    $175    3%
    70    11.8    2.6    56    2    1.142    199    2    98    1    1    35    8    2    30    37    0    $164    $170    4%
    71    12.4    2.6    57    7    1.476    171    1    91    1    0    28    8    2    47    41    1    $174    $181    4%
    72    8.1    3.3    79    2    0.546    122    4    129    1    0    56    3    5    33    74    0    $163    $170    4%
    73    9.5    2.0    53    19    1.295    110    1    88    1    0    40    8    3    49    31    1    $175    $182    4%
    74    8.4    1.8    47    10    1.512    73    0    82    0    1    31    7    2    41    22    1    $174    $180    3%
    75    9.0    1.8    39    9    0.103    89    5    135    1    0    40    20    2    47    16    1    $170    $176    4%
    76    15.5    3.1    75    4    0.185    166    5    133    0    0    29    15    1    32    97    1    $178    $187    5%
    77    10.4    2.1    51    5    0.636    118    3    112    1    0    32    10    2    35    26    1    $173    $180    4%
    78    12.7    2.2    51    7    0.172    117    5    168    1    1    33    11    5    36    23    0    $176    $184    5%
    79    14.0    3.0    74    18    0.044    175    3    78    1    1    39    7    3    45    84    0    $179    $187    4%
    80    9.4    2.0    50    11    1.545    102    3    110    1    0    41    10    3    41    28    1    $162    $169    4%
    81    14.0    2.5    70    5    0.291    182    3    132    1    1    31    6    2    35    74    1    $168    $173    3%
    82    15.9    2.5    66    9    0.092    230    4    137    0    0    43    12    3    36    65    0    $165    $174    5%
    83    7.5    1.6    43    5    0.480    59    3    127    0    0    30    4    2    35    17    0    $170    $175    3%
    84    8.1    1.9    49    16    0.983    71    4    112    1    0    39    7    3    45    23    0    $175    $180    3%
    85    10.3    2.1    49    3    1.881    46    1    85    0    1    46    9    3    36    17    0    $184    $194    5%
    86    7.7    1.9    46    3    2.626    43    2    74    0    0    50    4    4    50    21    0    $176    $180    2%
    87    8.5    1.9    53    21    0.568    125    3    109    0    0    44    8    3    45    34    0    $160    $167    4%
    88    10.7    2.2    62    8    0.879    118    3    108    0    1    31    10    2    37    50    1    $173    $180    4%
    89    7.4    1.8    51    4    1.083    101    2    100    0    0    53    7    4    34    28    0    $163    $167    2%
    90    14.8    2.6    70    6    0.828    213    3    105    1    1    37    15    2    37    75    1    $168    $176    5%
    91    7.3    1.9    56    24    1.560    115    5    87    1    0    46    1    4    45    37    0    $162    $166    2%
    92    7.6    1.8    42    1    1.428    121    4    84    1    0    45    5    4    24    14    0    $160    $165    3%
    93    9.0    1.9    56    3    1.404    69    1    87    1    0    34    8    2    32    38    0    $174    $181    4%
    94    12.9    2.1    60    5    1.072    178    2    101    1    1    38    13    2    36    49    1    $175    $183    5%
    95    9.0    1.9    48    12    0.183    85    4    130    1    0    37    11    2    38    22    0    $171    $178    4%
    96    18.2    3.6    88    12    1.600    282    0    72    1    1    39    18    1    41    29    1    $175    $185    6%
    97    14.4    3.0    75    5    0.612    156    5    129    0    1    42    15    4    36    55    1    $186    $193    4%
    98    8.8    2.0    56    3    0.496    86    3    100    0    0    54    8    4    31    37    0    $172    $179    4%
    99    12.5    2.5    60    17    1.800    212    2    86    1    1    39    9    3    44    40    0    $165    $171    4%
    100    13.3    2.2    58    6    0.403    157    2    98    0    1    35    16    1    36    45    1    $174    $180    3%
    101    12.5    2.4    67    10    0.856    91    3    112    1    0    33    1    3    38    43    0    $178    $188    6%
    102    13.2    2.8    73    15    1.836    169    0    85    0    1    36    7    2    42    83    1    $179    $187    4%
    103    11.1    2.5    70    20    0.408    175    2    96    0    0    42    7    6    47    49    0    $161    $168    4%
    104    8.3    1.9    49    4    0.124    77    3    150    0    0    29    10    1    32    24    1    $168    $175    4%
    105    9.3    1.9    55    11    0.085    125    7    107    1    0    38    4    5    32    35    0    $162    $169    4%
    106    8.2    1.7    49    13    0.852    102    3    108    1    0    37    9    4    41    25    0    $162    $168    4%
    107    14.8    3.3    74    6    1.927    249    2    78    1    1    29    7    2    38    58    0    $164    $171    4%
    108    10.7    2.0    53    4    1.018    134    1    86    0    1    36    10    4    35    31    0    $176    $182    3%
    109    8.8    2.1    58    13    0.864    129    4    133    1    0    61    8    5    44    39    0    $162    $168    4%
    110    9.7    2.0    54    2    0.626    51    2    107    1    0    38    8    3    28    26    0    $185    $193    4%
    111    9.7    1.9    55    4    1.384    33    2    100    1    0    27    10    1    34    94    1    $182    $192    5%
    112    10.5    2.2    65    3    0.590    121    3    108    1    1    32    10    2    29    54    0    $173    $181    5%
    113    8.9    1.7    39    7    0.072    116    7    155    1    1    44    16    2    35    8    1    $164    $170    4%
    114    7.9    1.8    42    4    1.283    68    4    90    1    0    37    6    3    36    17    0    $170    $175    3%
    115    21.0    3.3    89    6    0.075    296    0    137    1    1    37    13    1    36    27    1    $184    $196    7%
    116    12.7    2.2    65    6    0.899    165    1    140    0    1    60    9    5    35    62    0    $169    $174    3%
    117    9.4    1.9    49    10    1.248    92    2    98    0    0    53    12    4    42    25    0    $175    $182    4%
    118    7.5    1.8    51    18    0.231    109    5    111    1    0    41    7    3    49    29    1    $162    $165    2%
    119    11.8    1.8    53    7    1.512    125    2    101    1    0    39    13    2    36    32    0    $172    $179    4%
    120    11.4    3.6    96    1    0.831    199    3    109    1    0    44    10    4    24    65    0    $162    $168    4%
    121    7.2    1.9    56    4    0.123    113    3    132    0    0    45    6    3    31    36    0    $161    $167    4%
    122    20.4    3.3    79    7    0.131    284    4    137    0    1    38    15    5    39    39    1    $175    $185    6%
    123    9.8    1.9    64    5    1.539    115    4    72    1    1    36    8    2    35    50    1    $175    $183    5%
    124    16.2    2.9    67    9    0.637    188    4    76    0    1    30    12    1    37    49    1    $181    $190    5%
    125    11.4    2.3    65    9    0.275    139    1    124    0    1    34    11    2    40    59    1    $169    $174    3%
    126    18.3    3.2    89    6    0.711    232    4    99    0    1    47    13    3    37    89    1    $183    $193    5%
    127    8.7    1.8    53    10    1.200    83    2    90    1    1    33    8    2    39    109    1    $172    $179    4%
    128    9.1    1.8    44    14    1.227    100    5    98    1    0    37    10    4    41    20    0    $173    $180    4%
    129    9.7    1.8    46    7    1.963    113    4    85    1    0    28    10    1    39    22    0    $176    $181    3%
    130    6.6    1.6    58    17    0.496    100    2    136    0    0    42    5    3    43    39    0    $161    $165    2%
    131    9.1    2.2    62    23    0.424    123    2    75    0    0    49    12    3    48    43    1    $157    $162    3%
    132    9.7    2.1    62    11    1.152    106    2    96    1    1    42    8    3    42    49    0    $171    $178    4%
    133    7.8    2.1    46    17    1.481    126    3    97    0    0    40    1    6    47    24    0    $160    $165    3%
    134    13.9    2.4    66    7    2.285    200    3    124    1    1    32    9    2    32    62    0    $171    $177    4%
    135    10.3    2.2    56    11    0.292    47    3    111    1    0    34    9    2    38    30    0    $179    $186    4%
    136    11.7    3.0    82    15    0.888    202    5    147    1    1    40    7    3    42    61    1    $156    $163    4%
    137    9.4    1.8    44    12    2.324    97    2    101    1    0    49    19    3    32    21    1    $172    $179    4%
    138    9.5    1.9    44    10    0.196    49    3    111    1    0    33    12    2    40    15    0    $181    $189    4%
    139    8.7    2.1    51    15    0.180    84    4    122    1    1    40    8    3    43    26    1    $171    $180    5%
    140    12.8    2.9    70    13    1.416    209    2    85    1    1    45    6    3    40    57    0    $169    $175    4%
    141    6.6    1.7    44    2    0.115    70    3    137    0    0    46    6    3    29    19    0    $161    $167    4%
    142    17.0    3.0    75    7    0.995    185    2    99    1    1    30    10    2    39    58    1    $180    $189    5%
    143    16.7    3.0    68    4    2.352    209    0    85    1    1    30    12    2    50    51    1    $182    $189    4%
    144    15.9    3.4    84    9    1.259    175    1    84    1    1    31    8    2    37    76    1    $183    $190    4%
    145    7.9    2.0    51    3    1.464    118    4    115    1    0    46    6    4    33    31    0    $162    $167    3%
    146    14.1    3.3    88    5    0.504    253    3    124    0    1    42    9    3    35    63    1    $163    $172    6%
    147    8.1    1.7    58    19    0.447    20    4    129    1    0    43    10    3    42    35    0    $178    $184    3%
    148    13.6    2.9    66    17    2.620    103    2    102    0    1    39    8    3    50    48    0    $166    $172    4%
    149    10.0    2.0    55    8    1.168    120    3    114    1    0    52    10    3    40    34    0    $174    $182    5%
    150    11.6    2.2    60    9    0.032    102    5    135    1    1    35    8    2    32    37    0    $178    $185    4%
QtrSalesData
    Time Period    Quarter    t    Total Sales ($m)
    1    2014-Q2    1    55.4
    2    2014-Q3    2    58.9
    3    2014-Q4    3    66.1
    4    2015-Q1    4    52.2
    5    2015-Q2    5    61
    6    2015-Q3    6    70
    7    2015-Q4    7    85
    8    2016-Q1    8    59.2
    9    2016-Q2    9    77
    10    2016-Q3    10    88
    11    2016-Q4    11    109
    12    2017-Q1    12    72.5
    13    2017-Q2    13    93.2
    14    2017-Q3    14    115
    15    2017-Q4    15    133
    16    2018-Q1    16    94
1
    Sales $m    OnlineChannel
    12.5    1        Sales $m                                    Row Labels    Sum of Sales $m
    14.5    1                                            5-7.5    68.6
    19.0    1        Mean    11.6593333333                                7.5-10    452.3
    18.2    0        Standard Error    0.2915699948                                10-12.5    357.4
    7.6    0        Median    10.95                                12.5-15    383.2
    18.5    1        Mode    8.1                                15-17.5    291.5
    13.1    0        Standard Deviation    3.5709885584                                17.5-20    131
    14.9    0        Sample Variance    12.7519592841                                20-22.5    41.4
    17.1    1        Kurtosis    0.0077411553                                22.5-25    23.5
    9.2    1        Skewness    0.7447995814                                Grand Total    1748.9
    10.3    1        Range    17.6
    19.3    1        Minimum    5.9
    8.1    0        Maximum    23.5
    9.1    0        Sum    1748.9
    15.7    1        Count    150
    9.8    1
    19.5    1        Row Labels    Count of OnlineChannel
    16.2    1        0    88
    8.0    0        1    62
    12.2    1        Grand Total    150
    11.1    1
    16.8    1
    11.8    0
    14.0    1
    10.5    0
    6.2    0
    16.9    1
    7.9    0
    9.6    0
    16.3    1
    11.2    0
    13.1    1
    8.0    0
    16.1    0
    10.4    0
    7.4    1
    10.5    0
    12.0    0
    14.5    0
    5.9    0
    9.0    1
    15.8    0
    14.0    0
    15.3    0
    14.4    0
    14.8    0
    12.1    0
    8.0    1
    8.4    0
    10.6    0
    10.9    0
    8.7    0
    9.5    0
    6.8    0
    7.2    0
    11.3    0
    9.4    0
    8.6    1
    17.1    1
    15.4    1
    11.0    0
    15.6    0
    7.6    0
    11.4    1
    23.5    1
    12.4    0
    13.4    1
    13.8    0
    11.6    0
    11.8    0
    12.4    1
    8.1    0
    9.5    1
    8.4    1
    9.0    1
    15.5    1
    10.4    1
    12.7    0
    14.0    0
    9.4    1
    14.0    1
    15.9    0
    7.5    0
    8.1    0
    10.3    0
    7.7    0
    8.5    0
    10.7    1
    7.4    0
    14.8    1
    7.3    0
    7.6    0
    9.0    0
    12.9    1
    9.0    0
    18.2    1
    14.4    1
    8.8    0
    12.5    0
    13.3    1
    12.5    0
    13.2    1
    11.1    0
    8.3    1
    9.3    0
    8.2    0
    14.8    0
    10.7    0
    8.8    0
    9.7    0
    9.7    1
    10.5    0
    8.9    1
    7.9    0
    21.0    1
    12.7    0
    9.4    0
    7.5    1
    11.8    0
    11.4    0
    7.2    0
    20.4    1
    9.8    1
    16.2    1
    11.4    1
    18.3    1
    8.7    1
    9.1    0
    9.7    0
    6.6    0
    9.1    1
    9.7    0
    7.8    0
    13.9    0
    10.3    0
    11.7    1
    9.4    1
    9.5    0
    8.7    1
    12.8    0
    6.6    0
    17.0    1
    16.7    1
    15.9    1
    7.9    0
    14.1    1
    8.1    0
    13.6    0
    10.0    0
    11.6    0
Pie...
SOLUTION.PDF
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?