DSCI 3321, Spring 2015
I. Included as a separate handout in Excel are the data that was gathered from your section on the first day of class. Load these data into Excel. Conduct the following analysis to describe your class (Load the data before attempting the analysis). You must hand in hard copy. Electronic
versions of the assignment will not be accepted.
1) Construct a frequency distribution and a histogram for the variables, "Age" and "Number of Miles to Class 1-Way".
Note: You will probably have to add-in the Data Analysis feature the first time. Here’s how:
Click on the Office icon in the upper left of your screen. Now click on “Excel Options” at the bottom. Next click on “Add-ins” (to the left). Highlight “Analysis ToolPak” and select “Go..”
A dialogue box will appear. Check the box beside “Analysis ToolPak” and click OK. If asked “Would you like to install it?”, click “Yes”. It usually will bring it up – takes a few minutes.
From now on, the Data Analysis feature will be available on your computer.
Click on the Data Analysis feature (under Data tab). A series of options will appear in a pull-down menu. We will be using these all semester. Select Histogram. Under Input Range put the location of the "Age" data (perhaps something like B6:B39) if your data are in these cells in column B or just click and drag over them (my preferred method). At the bottom left of the histogram dialog box, check the box for New Worksheet Ply. This will place your output on a
New worksheet. Also, check the bottom box, Chart Output. The answer for the histogram will be two shorter columns entitled ‘Bin’ and ‘Frequency’. These are really a frequency distribution as we know it. The histogram graph will usually be displayed to the right of the bin and frequency. You can stretch the graph so that it is larger and easier to see by clicking on the boundary and pulling it down or out. Print out the bin and frequency values along with the histogram chart. Comment on the general shape of the graph. Is it like a normal curve (bell-shaped)? Or is it skewed in some way? Do the same analysis on the "Number of Miles to Class 1-Way".
2) Compute Descriptive Statistics for each variable of this class data for which this makes sense: age, miles, minutes, total credit hours being taken, number of hours worked per week, number of meals eaten out per week, and number of books read per year outside of class books.
In the Descriptive Statistics dialog box place the location of the column of data to be analyzed in Input Range. Be sure to check Summary Statistics at the bottom left of the box. Now click OK. Notice the data output. This is pretty nifty output. Be sure to expand the columns width-wise to allow complete viewing of the output. This is done by going to the top of the column by the A, B, C, etc. and clicking and dragging from the little vertical line over to the right. Do this for each variable (age, miles, etc.) of data. Print out the descriptive statistics for each set of data. It’s not a bad idea to attempt to place all of the output for this question on one page (saves paper). If you have a one-cell title for a column, check Labels in First Row. Otherwise, if you don’t check this, it will tell you that you have non-numeric data. On the other hand, if you check Labels in First Row, but you only have numbers, Excel will take your first number and make it the title and your answers will be all off.
3) Determine the percentage of people in the class who: 1.) are male vs. female, 2.) will go out of state during Spring Holidays, 3.) prefer each of the four types of restaurants, and 4.) prefer diet soft drinks. Do this using in Excel by creating a Pie chart for each and have Excel enter the label and percentage (see question 4 below for directions on pie chart construction).
4). Work problem 2.15 a. and b. from the 8###sup edition using Excel. This is not from the class survey. It is the semiconductor company data from the text.
Place the names of the Firms in column 1 and the Revenue in column two. Do not place a title over each column (or do not include it in the data location specification).
5) "Describe your class"
Using the graphs and descriptive statistics produced in 1), 2), 3) and 4) above, describe your class in words. Write at least three pages doubled spaced. Include observations gleaned from the information produced using Excel. Discuss each of the 11 variables (age, miles, etc.) used in the database. Can you generalize about the class? Support your discussion with a lot of statistics. This written analysis will be graded using the Elements and Standards of Critical Thinking to include clarity, breadth, and interpretation using information.
Length: 3 pages (994 Words)
The frequency distribution for the age revealed that majority of the students in the class were aged between 20 and 23.3 years. This is because the age group had the highest frequency of 18 (50.0%). The second largest group of students in the class are aged below 20 years with a frequency equal to 6 (16.66%). Other frequencies were equal to 5 (13.89%), 1 (2.78%), 2 (5.56%) and 4 (11.11%) for the age groups 23.3-26.6, 26.6-30, 30-33.3 and more than 36.6 respectively.
* Once your purchase is processed by paypal you will be redirected back to this page and you'll have the option to download the paper. We'll also send the paper to your paypal email address as proof of purchase.Download Paper