Assgt_2 - DSCI3710 EXCELASSIGNMENT#2

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
DSCI 3710 EXCEL ASSIGNMENT #2   We assume that all students have had an introduction to spreadsheets.  The instructions given  below are an outline of the steps you need to take in order to complete your assignment.   These  instructions build on the ones given for the first assignment  and therefore should be regarded  as a guide and not as a detailed map of the complete procedure.  Further help on maneuvers in  Excel is available by clicking on the Excel Help menu. Please be sure to read the case description for each problem before you begin the computer  exercise. By so doing, you will have a clearer understanding of the purpose of the exercise and  how you will conduct the analysis.  This could help reduce the amount of time you spend in the  computer lab on this assignment.   Answer the questions listed in this handout.   Currentprices.com keeps a record of the sales prices of gasoline ($/ gallon, at pump) at different retailing pumps/ locations. The data on regular unleaded gasoline, as recorded at 37 different pumps at 4 different locations, viz., Allen, Blaze, Corlis, and Dustin. The data is presented in the spreadsheet entitled Assgt#2.xls . You have to: (1) Analyze the data for the existence of any difference between the true mean prices at the four different locations using the ANOVA procedure; (2) conduct Tukey’s multiple comparison procedure on the data; (3) construct a 95% confidence interval for the mean price of regular gasoline in Allen; and (4) construct a 95% confidence interval for the difference between the mean prices in Dustin and Blaze. The general procedure is outlined below. 1. Open the file Assgt#2.xls. 2.  Insert a row (under Edit menu) at the top of the spreadsheet then label the columns A, B, C, 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Assgt_2 - DSCI3710 EXCELASSIGNMENT#2

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online