### Question Description

I don’t know how to handle this Statistics question and need guidance.

You will need to be familiar with using the MINITAB. There are 6 simple questions, some questions must use minitab to answer.

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Final Answer

Attached.

Question 1

The Minitab file that you require for this question should be downloaded from the

‘Assessment’ area on the module website.

The data used in this question are about the numbers of students on three of

the five most popular modules at the OU. The variable ModuleName contains

the name of the module, and the variables 2015/16, 2016/17, 2017/18,

2018/19 contain the number of students at the start of each of the modules

in each of the academic years 2015/16 to 2018/19. The variable

MedianNumber contains the median of the number of students on each

module. These data are given in the Minitab worksheet popular

modules.mtw. Run Minitab and open this worksheet.

The mean number of students on a module over the four years is mean

number = (2015/16 + 2016/17 + 2017/18 + 2018/19)/4.

(a) Calculate by hand the median number of students on AA100 and show all

your working in your answer. (You can check that you have the same

answer as in the Minitab worksheet.)

To get the median, we arrange values in ascending order. For count of data

that is odd, for example 5, then the median is the middle value but for an

even number count of data, the median is the average of the two middle

values.

For AA100 data;

AA100-The arts past and present

4960

4404

4504

4366

In ascending order; 4366, 4404, 4504,4960

The median = (4404+4504)/2 = 4454

(b) Use Minitab to produce a column of values, headed MeanNumber, containing

the mean numbers of students on each module. Include this

column of values in your answer.

ModuleName

AA100-The arts past and present

B100-An introduction to business and management

MST124-Essential mathematics 1

MeanNumber

4558.5

4138.25

3514.5

(c) Use Minitab to calculate a column of values, headed Diff, containing the

differences between the mean and the median numbers of students on

each module. Use Minitab to round the differences to the nearest whole

number, i.e. zero decimal places, and include this column of

values in your answer.

ModuleName

AA100-The arts past and present

B100-An introduction to business and management

MST124-Essential mathematics 1

Diff

105

93

111

(d) The range of the number of students on MST124 over the period is 1209.

Using Minitab, or by hand, calculate the corresponding ranges for

AA100 and for B100. What does the comparison of the ranges tell

you about the numbers of students on MST124?

ModuleName

AA100-The arts past and present

B100-An introduction to business and management

MST124-Essential mathematics 1

Range

594

1086

1209

The ranges for AA100 and B100 are 594 and 1086 respectively. This indicates

that the variability in MST124 is much greater than for the other courses.

Question 2

The Minitab file that you require for this question should be downloaded from the

‘Assessment’ area on the module website.

The data used in this question relate to a measure of UK biodiversity. Insects

are important pollinators and each year the number of 1km grid squares in

which insect pollinators are found is recorded. An ‘occupancy index’ is

calculated from these data and scaled so that for the first year (1980) the

index is 100. (Data source: jncc.defra.gov.uk/page-6851.) These data are given

in the Minitab worksheet pollinators.mtw. In the worksheet, for each year,

the variable All Index contains the occupancy index for all insect

pollinators and the variable Bees Index contains the corresponding

indicator for wild bees only. Run Minitab and open this wor...