logo

The Basic Practice of Statistics Assignment

This project involves completing four separate exercises using a spreadsheet software package of your choice, and submitting a paper copy of the spreadsheet for each exercise. The exercises will be graded based on accuracy, appearance/organization, and completion.

4 Pages442 Words21 Views
   

Added on  2022-08-25

The Basic Practice of Statistics Assignment

This project involves completing four separate exercises using a spreadsheet software package of your choice, and submitting a paper copy of the spreadsheet for each exercise. The exercises will be graded based on accuracy, appearance/organization, and completion.

   Added on 2022-08-25

ShareRelated Documents
BASIC PRACTICE OF
STATISTICS
STUDENT ID:
[Pick the date]
The Basic Practice of Statistics Assignment_1
Exercise 1: Descriptive Statistics
The requisite steps stated in part A, B,C have been enacted in the attached spreadsheet. The
result obtained from this is summarised as the screenshot below.
Using the various descriptive statistics functions available in Excel, the mean, median,
standard deviation and range for the various follows have been estimated as follows.
The relationship between the three means (i.e. μ, μ1 and μ2) can be described as follows.
μ = μ1 - μ2
It needs to be analysed if the above relationship extends to standard deviation as well or not.
σ = 3.1 , σ1 = 3.1 and σ2= 2.5
From the above values, it is evident that the relationship observed in mean is not observed
with regards to standard deviation.
The Basic Practice of Statistics Assignment_2

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Hypothesis and Sampling
|12
|775
|479

Statistics. Statistics Student name: Tutor name:. 1|Pag
|4
|455
|86

SPSS Analytical Report
|13
|2171
|122

Data and Business Decision Making
|15
|1220
|381

Statistics for Business
|10
|733
|61

Statistics | Questions and Answers
|9
|1072
|37