## Question

# Statistics Assignments Using Excel Assignment #4: Measures of Variability Part I Below are ACT composite scores from 20 randomly selected college students. 15 33 20

**Statistics Assignments Using Excel**

**Assignment #4: Measures of Variability**

Part I

Below are ACT composite scores from 20 randomly selected college students.

15 33 20 25 21

24 17 16 20 25

26 21 21 17 28

21 24 19 19 24

Enter the data into a spreadsheet and calculate the following descriptive statistics: mean,

median, range, interquartile range, sample variance, sample standard deviation, estimated

population variance, and estimated population standard deviation.

Calculate the variances and standard deviations using spreadsheet functions (VAR,

VARP, STDEV, STDEVP) **AND** by creating your own formulas.

Be sure all your work is shown and clearly labeled, and label the entire worksheet "ACT

Scores".

Part II

The data below are the milliliters of alcohol consumed for 15 rats in an experiment investigating

the effectiveness of a drug designed to inhibit the pleasurable effects of alcohol intoxication.

80 105 115

110 100 110

85 95 70

90 110 85

115 140 90

Enter the data in a new worksheet (not workbook!)

Calculate the same descriptive statistics you did for the ACT data (first using functions,

then with formulas)

Label the worksheet "alcohol data."

## Step by Step Solution

There are 3 Steps involved in it

### Step: 1

Lets break down your assignment into parts and steps to ensure everything is calculated correctly Part I ACT Scores Data Entry First enter the ACT sco...### Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

### Step: 2

### Step: 3

## Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started