

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
A computer exercise for stat 3000 students in the fall 2001 semester. The exercise focuses on data presentation and descriptive statistics using microsoft excel. Students are required to complete the exercise individually or in groups, and submit an original printout with computer-generated graphs, tables, and explanations. The exercise covers creating bar charts, pie charts, histograms, and obtaining descriptive statistics and quartiles for the variables 'weight' and 'height' from the student data set.
Typology: Papers
1 / 2
This page cannot be seen from the preview
Don't miss anything!


STAT 3000 Section 003 Fall 2001
**Due: Thursday, September 20, 2001 Name(s): Points: 75 ________________________
________________________**
The purpose of this computer exercise is to make you familiar with computer-based statistical data analysis. This exercise will introduce you to exploratory data analysis using Microsoft Excel.
You have to complete the exercise using a computer and turn in an original printout. The printout should be concise and contain computer-generated graphs and tables. The printout should be carefully annotated (all graphs and tables must be numbered - either by hand or typed). Additional comments and explanations should be provided on a separate sheet of paper (either by hand or typed). In order to reduce the number of pages to print, it might be useful to import or copy graphs and tables into a text processor (such as Microsoft Word) where you can edit them, e.g., adjust their size so that more than one graph and/or table fit on one page.
References:
To complete this exercise, you will have to consult the following sources of information:
Grading criteria:
The maximum number of points for this exercise is 75. The following components will be considered when grading your exercises:
Correctness of graphs and calculations 30% Labeling 20% Overall appearance and technical quality 30% Explanations and comments (where applicable) 20%
You can work on this exercise individually or in groups of max. 4 students. If you work in groups, make sure that the names of all group members are listed on the printout. Please turn in only one printout per group. It will be assumed that all members have contributed equally to the final outcome of the exercises. All members will be given the same number of points.
Exercise 1 (started on 09/13/2001 in class)
For this exercise, you will use the student data set collected in class and available on the Web as Microsoft Excel file at http://www.math.usu.edu/~vukasino/teaching/fall2001/Data/student_data3.xls