Reference no: EM132527575

BUS105 Business Statistics - King's Own Institute

Learning Outcome 1: Identify practical business situations to which statistical techniques are applicable

Learning Outcome 2: Present, summarise and manipulate sample data, make basic statistical inferences and interpret the results in a business context

Learning Outcome 3: Use one or more current statistical software packages for basic data analysis purposes

Learning Outcome 4: Apply skills in identifying problems and solution strategies.

Computer assignment - analysis

Purpose: To allow students to demonstrate an understanding of statistical analysis and the ability to summarise and manipulate sample data, make basic statistical inferences and interpret the results in a business context. This assessment contributes to learning outcome 1, 2, 3 and 4.

Assignment Task - Each individual student will be provided with their own unique dataset and they will have to summarize the dataset using PivotTable and Scatterplot command using Microsoft Excel.

Students will also download questions about their summaries from Moodle. Students will also download a sample report and questions about the sample report from Moodle. The questions will check that students can make basic inferences, check they understand how to use statistics in business and know how to write a report using statistics.

Overview
Materials that must be used in the assignment, these are provided on moodle
*A pair of datasets for country 1 and country 2. Looking at the datasets you will notice that each student has been given a sample, students must use their own sample.

*An automatic dataset summarizer.

*Instructions for checking that you have properly found your sample, students must use their sample.
Students must submit a word file AND an excel file to moodle
¬*The word file needs to be submitted to the Turnitin link, the word file needs a cover page and the answers to 9 questions given in full detail later in this document (pages 2 to 7) a vital part of answering the question is using the dataset and the dataset summarizer.

*The excel file needs to be submitted to the assignment dropbox, the excel file should have the students dataset for country 1 and summaries NOT made by the automatic dataset summarizer students need to summarize the dataset using PivotTables and the scatterplot. Instructions for submitting the excel file are given on page 8"

Preparatory Quizzes: Before you start summarizing your dataset, you need to do the Preparatory Quizzes to ensure you are familiar with the concepts and techniques involved. You may attempt the Quizzes as many times as you like - each new attempt will overwrite the previous attempt. Only the last attempts will be marked.

Attachment:- Business Statistics.rar