Business Statistics Theory

If you are looking for affordable, custom-written, high-quality, and non-plagiarized papers, your student life just became easier with us. We are the ideal place for all your writing needs.


Order a Similar Paper Order a Different Paper

  • The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2 cm margins on all four sides of your page with appropriate section headings.

Reference sources must be cited in the text of the report and listed appropriately at the end in a reference list using APA or IEEE referencing style for School of Business and School of Information Technology and Engineering respectively.

Assignment Description

Students are required to produce an individual assignment using data provided. Data is available on MA508 Moodle shell in the folder named [Data set]. You need to use Business Statistics theory, concepts, tools and terminology that you have learnt from weeks 1 to 5 to analyse the data and to write up the assignment.

Data set [Global Corporation –Customer attributes &Sales data] is obtained from a global corporation. The business sells categories of products including DVD, CD, and books which include classical, novel, politics, and bestsellers.

You have been given a data set which include the data for 400 days of trading.

  • The datasheet is labelled [customer attributes& sales] lists the results of an online survey given to customers.
    • The customer variables include:
      • Customer ID
      • “Gender” – male or female
      • Marital status (Married, single, divorced, widow)
      • Age
      • Type of customer (light user, medium user, heavy user)
      • Region that they come from (east, west, south, north)
      • Payment which defined customers’ payment methods (Paypal, credit, cash)
      • Source (web, email, shop)
      • Amount of customer’s pay
      • Product that they have purchased (Best select, CD, Classical, DVD, Novel, Politics).
      • Salary
      • Opening Gross Sales
      • Total Gross sales for the days.
      • Price over earning ratio
      • Gross profit margin (%)
      • Revenue ($000)
  • The sales variables include.

    Assignment instructions:

    The main challenge in the business is to increase sales, revenue and profit. For this reason the company has decided to conduct a survey and identify the reasons for this. They have collected the data for customers’ demographics and sales.

    Using statistical theory and application answer the main research questions below. Also by using the dataset create and answer any other research questions that are meaningful to you.

    Assignment structure:

    • Introduction– Introduce the business problem. (10 marks)
    • Identifying the data types and measurement scales of all variables in the dataset (10marks)
      • Calculate descriptive statistics for all numerical variables (20 marks)
        • Discuss whether you can calculate numerical variables (10 marks)
          • Methods of data summarising (30 marks)
            • Pivot table and covariance (10 marks)
              • Discussion of the results and recommendations (10 marks)
                • Describe the main objective of the researchers who collected this dataset
                • Describe how you want to achieve this objective in this assignment
                • Create a table containing all names of variables and the associated data type as well as the scale of measurement
                • measures of location,
                • measures of variation such as
                • For nominal categorical variables and why?
                • For ordinal categorical variables and why?
                • Create two frequency tables for two different categorical variables
                • Create corresponding bar chart and/or pie chart
                • Create two frequency tables for two different numerical variables
                • Create two corresponding histograms
                • Create Pivot table of region, payment and source and interpret the table.
                • Create covariance of amount paid and salary and interpret the table.
                • Consider the business issues you listed in the introduction for which the above analytic methods can help
                • What is your conclusion

                such as median, sample average, selected percentiles

                variance, standard deviation, range, interquartile range

                Submission: You need to submit assignment in word document, and in Excel file for data analysis.


                MA508 Business Statistics Assignment [Individual] Marking Guide (10 Marks)

                Criteria

                Possible Marks%

                Marks Allocated

                • Introduction– Introduce the business problems
                • Identifying the data types and measurement scales of all variables in the dataset
                • Calculate descriptive statistics For all numerical variables
                • Discuss whether you can calculate numerical measures
                • Methods of data summarising
                • Pivot table and covariance
                • Discussion of the results and recommendations

                10

                10

                such as median, sample average, selected percentiles

                variance, standard deviation, range, interquartile range

                20

                10

                30

                10

                10

                Total

                100%

                Overall Comments:

                = _____/10

                Are you stuck with another assignment? Use our paper writing service to score better grades and meet your deadlines. We are here to help!


                Order a Similar Paper Order a Different Paper
                Writerbay.net