MCD2080 Business Statistics Assignment 代写

  • 100%原创包过,高质量代写&免费提供Turnitin报告--24小时客服QQ&微信：273427

    • MCD2080 Business Statistics Assignment 代写

     
    MCD2080 Business Statistics Assignment
    Descriptive Statistics (Using Excel)
    This assignment is marked out of 63 and is worth 10% of the assessment for the unit.
    It is designed to test your understanding of Descriptive Statistics using Excel.
    Submission Details
    Hard copy (Microsoft Word document: printed)
    Submit your assignment, by the due day and time, to the MCD2080 Assignment Box - as a printout of
    a Microsoft Word document. You must include a completed Cover Sheet, which has been signed and
    dated. Your tutor will mark only this hard copy.
    Soft copy (Microsoft Word document: electronic file)
    You must also submit your assignment on the MCD2080 Moodle site via the upload link. Submit
    only one (1) Word file - without the Cover Sheet. You may submit this soft copy at any time before
    the due day and time. The file must be labelled using your Given Name, Surname and ID, for
    example, Huan Wang_12345678.docx. The soft copy is a back-up. Your tutor will not print or mark
    this soft copy.
    Late submissions
    If you are unable to submit the assignment by the due day and time, you may wish to apply for
    Special Consideration. Place late assignments in the MCD2080 Assignment Box and also submit
    them on Moodle.
    A penalty of up to 5% of the total mark allocated to this assignment may apply for each day an
    assignment is late (unless a staff member grants an extension of time).
    Data and Output
    The file MCD2080_A1_T117.xlsx contains the assignment data in the worksheet labelled Data.
      You must use Excel to generate the output.
      We recommend that you create your graphs and tables in the Data worksheet. (You must work
    in this way on some computers, e.g. network computers, because Excel’s Data Analysis Tools
    may work only on the worksheet where the data resides.)
      Copy your graphs and tables from the Data worksheet and paste them to your Word document.
    This document must be labelled using your name and ID, for example,
    Huan Wang_12345678.docx
      Do not print out the data in the Data worksheet.
      The presentation of the assignment is important, and some marks are allocated for this. Your
    work must be easy to read (eg, a whole table should not partly presented on two pages). The
    recommended font size is 10 - 14 point. However, elaborate features are not required.
    Due Date: by 10 am Monday of Teaching Week 5
    2
    Background
    EasyBuy is an online retailer of large varieties of many categories of item: sports, fashion, electronic,
    etc. The worksheet Data in MCD2080_A1_T117.xlsx contains data on the 200 customers who
    responded to a promotional one-day offer emailed to all customers on the EasyBuy database. The
    manager wants to analyse the data for customer buying-patterns which will guide future promotions.
    The data for each customer includes
      AmountSpent The total amount ($) spent on the promotion day.
      Membership EasyBuy membership status: 1=member, 0=non-member.
      Region Shipping region: 1=central, 2=northern, 3=southern.
      Highitem  The category of the highest-priced item purchased:
    1=electronic, 2=fashion, 3=sports and 4=other goods.
      Items  The number of items purchased.
    Questions
    1. Explain the data type for each of the following variables. 
    (a) Membership  (b) Items
    If the variable is categorical, also explain whether it is nominal or ordinal.
    If the variable is numerical, also explain whether it is discrete or continuous.
    [4 marks]
    Questions 2 – 10, below, are based on the 200 customers who responded to the one-day offer.
    2. Using Excel’s Pivot Table function, obtain the following tables and copy them into your Word
    document. Use the “Tabular Form” report layout and label your tables accurately and
    informatively. Round off percentage values to one decimal place.
    (a) Table 1: frequency distribution of the customers - broken down by Membership
    (“ROWS”) and Region (“COLUMNS”).
    (b) Table 2: the frequency distribution of Table 1, but with values shown as “% of Grand
    Total”.
    (c) Table 3: the frequency distribution of Table 1, but with values shown as “% of Row
    Total”.
    (d) Table 4: the frequency distribution of Table 1, but with values shown as “% of Column
    Total”.
    [6 marks]
    3.  For the following questions, where appropriate, justify your answers with suitable values from
    Tables 1 - 4. For each question, state the table (eg, Table 2) that you use. No calculation is
    needed. Quote percentage values to one decimal place.
    (a) How many customers in the southern region are EasyBuy members?
    (b) What proportion of customers are EasyBuy members?
    (c) What proportion of customers are from the central region and are not EasyBuy members?
    (d) What proportion of EasyBuy members are from the northern region?
    (e) Does the proportion of members exceed the proportion of non-members in all regions?
    Justify your answer.
    (f) Which region has the highest number of members? What is this number?
    (g) Which region has the highest proportion of members? What is this proportion?
    [9 marks]
    4.  In the Data worksheet, we wish to separate the AmountSpent data into members’ and non-
    members’ amounts.
    3
     Sort the data by Membership.
     In cell G1, type the heading Non-member AmountSpent; cell I1, Member AmountSpent.
     Copy the relevant data under the appropriate heading.
    Do not copy this table of separated data into your Word document.
    Use Excel’s Pivot Table function to create a percentage frequency distribution table for
     the Non-member AmountSpent values.
     the Member AmountSpent values.
    The class intervals (groups) should start at $20 and have a width of $30. Show percentages
    correct to 2 decimal places. Use the “Tabular Form” report layout and label your tables accurately
    and informatively. Copy these tables into your Word document.
    [4 marks]
    5.  Use the tables from question 4 to construct a percentage frequency histogram for the
    (a) Non-member AmountSpent values.
    (b) Member AmountSpent values.
    Ensure that the histograms are appropriately labelled.
    [6 marks]
    6.  Obtain the indicated summary measures in the following table, for
      Non-member AmountSpent,
      Member AmountSpent.
    Summary Measures  Non-members
    AmountSpent
    Members
    AmountSpent
    Mean 
    Median 
    Mode 
    Standard Deviation 
    CV (Coefficient of Variation) 
    Range 
    Minimum 
    Maximum 
    Sum 
    Count 
    Lower Quartile 
    Upper Quartile 
    IQR (interquartile range) 
    Modal class 
    [8 marks]
    7.  Refer to your results from questions 5 and 6.
    For the Non-member AmountSpent distribution,
    (a) describe the shape of the frequency distribution and provide evidence for your answer.
    (b) interpret this shape in context for EasyBuy.
    [4 marks]
    8.  (a) Briefly discuss the usefulness to EasyBuy management of each of the measures of central
    tendency in question 6, as well as the usefulness of the modal class. Justify your answers.
    (b) Which group of customers has the greater level of contribution to EasyBuy’s revenue?
    Discuss. Justify your answer with suitable values of the measures in (a).
    [7 marks]
    4
    9.  (a) Interpret in context each of the measures of variability in question 6.
    (b) Which group of customers has the greater variability of AmountSpent: Non-members or
    Members? Discuss.
    [6 marks]
    10. (a) Create a Pivot Table of the mean AmountSpent - broken down by Membership (Row) and
    Region (Column). Use the “Tabular Form” report layout and label your table accurately and
    informatively.
    (b) Construct a column chart of mean AmountSpent in relation to Membership and Region.
    Ensure that the chart is well-presented.
    (c) Which cohort of customers is most valuable to EasyBuy?
    Justify your answer with suitable values from the Pivot Table.
    [7 marks]
    Presentation
    In business, a high standard of presentation is usually required. In this unit, your submitted work is
    expected to be legible and well laid out. Legibility is enhanced by appropriate font size, borders,
    colour choice and labelling in graphs, as well as care in spelling, grammar and punctuation. Marks
    may be deducted for poor presentation.
    [2 marks]
    Excel Tips
    The Excel Notes document on Moodle also has information that you may need for this assignment.
    Sorting Data
    When sorting several of columns of data by one variable, first highlight the whole block of data (all
    rows and columns of the data set). If you highlight just the column for the variable by which you are
    sorting, then the values of this variable will be separated from the cases to which they belong.
    Percentage frequency histograms
    Use Excel’s “Column” Chart Type. To remove the gaps between the columns of a histogram,
      right-click on any column and choose “Format Data Series”.
      reduce the “Gap width” to “No Gap”.
    Data Analysis Tools
    If Data Analysis does not appear in the “Data” menu, consult Section E5 of the Excel Notes.
    Word Tips
    To capture a screen image & “Paste” it into Word
    To capture the image (eg, Excel page, internet page, photo, etc) currently displayed on your screen,
      use Windows’ Snipping Tool (available via the START button/All Programs/Accessories).
      go to the desired location in your Word document. Hold the Ctrl key and press the letter “V”.
    To trim (“Crop”) an image in Word
      Click on the image.

    MCD2080 Business Statistics Assignment 代写
      From the ‘ribbon’ at the top of the screen, select Format/Size and click on the “Crop” icon: 
      Apply the “Crop” icon to the image.
    To arrange graphs and pictures within a “Word” document
    Graphs (eg, from Excel) and pictures can be more manageable if you insert a table into Word and
    place your graphs and pictures (and text) into cells of the table.
    MCD2080 Business Statistics Assignment 代写