Statistics Excel work

# Statistics Excel work

Excel Exercise #2

The purpose of this exercise is to give students practice in creating interactive spreadsheets in the context of confidence intervals.

Each student will have different data. PLEASE DO NOT USE OTHER STUDENTS’ FILES—your data set is unique.

INSTRUCTIONS ON OPENING AND SAVING YOUR FILE:

1) Click on the Canvas link to download the spreadsheet.

2) Select “Enable Editing” to exit Protected View

3) Click “Enable Content” to run the macros

4) Now save your file by choosing Save As from the File menu.

a. When you open the file, it will be a Macro-Enabled file. Make sure to change this—save it as a regular Excel workbook.

b. Name your file “lastname.firstname.2” and save it as a regular Excel workbook (the first type under the list of file types).

5) You may now begin working on your assignment.

The data are given in column A in the spreadsheet. The data listed are the dollar amounts for a SAMPLE of 150 sales made across our company. We need to calculate a confidence interval to estimate the average dollar amount for a sale.

Make sure that your answers are given in column D, directly adjacent to the measurement requested. The cells that you need to fill in are outlined in red.

PLEASE DO ALL OF YOUR CALCULATING IN EXCEL.  YOU SHOULD NOT USE A CALCULATOR TO DO ANY PART OF THIS ASSIGNMENT.

DON’T EVER RE-TYPE A NUMBER. INSTEAD, REFER BACK TO CELLS WITH THE NUMBERS YOU NEED.

WHEN YOU FOLLOW THESE INSTRUCTIONS, YOUR SPREADSHEET WILL BECOME AN INTERACTIVE TOOL AND YOU WILL AVOID ROUNDING ERROR.

Comments are closed.