Week # 5
University of Phoenix
QRB501: Quantitative Reasoning for Business
May 4, 2009
Sevilla & Somers Text
Activity 17.1(1 only)
In the first part of this activity, you will generate some data that should have an approximately normal (or bell-shaped) distribution. In the second part, you will use the definition of standard deviation and compare the standard deviations for two different data sets.
1. Work with a partner to generate the following data.
a. Toss 10 coins and record the number of heads you obtained.
b. Repeat this 24 more times until you have a list of 25 numbers, each of them between 0 and 10. [pic]
c. Retrieve the file “EA17.1 Coins and Presidents.xls” from the CD or website, and you will find the results of 35 tosses of 10 coins that someone else carried out. When you first retrieve the file, column B contains the number of times 0 heads was obtained in the 35 tosses of 10 coins, the number of times 1 head was obtained in the 35 tosses, and so on, up to the number of times 10 heads was obtained. Add your results to the list so you have a total of 60 in column B. [pic]
d. Create a scatterplot of these data, using one of the versions of the scatterplot with the dots connected. Describe what your curve looks like, including where it is “centered” and what its “spread” is. [pic]
The scatter plot has a mountain look. The apex is at 5 and its spread expands from 0 to 10. The frequency of heads fell between 3-5.
e. Change your graph to a bar graph (instructions follow). [pic]
f. Print your bar graph, with appropriate titles on the axes, and by hand draw in a bell-shaped curve that “fits” this data. How does your hand drawn curve compare with the curve you described in part d of this question? [pic]
When the bell shaped curved is compared to the scatter plot graph, the bell shaped curve demonstrates a normal distribution or a symmetrical representation of the distribution. The scatter plot graph reflects the collection of points where each value is in position from the horizontal axis to the vertical axis. In essence, the scatter plot graph displays values from two variables of a set of data.
Topic 17, exploration 2
The following tables provide information about the top women-owned businesses in the U.S. The first table gives year 2000 revenue in millions of dollars and number of employees for Pennsylvania women-owned companies with year 2000 revenues of $70 million or higher. The second table gives the same information for Michigan women-owned companies with year 2000 revenues of $70 million or higher. a. Use a calculator or computer to compute the mean and standard deviation of the year 2000 revenue for the Pennsylvania companies in the first table. [pic]
|Pennsylvania Companies |2000 Revenue ($ millions) |Standard Deviation | |84 Lumber |2000 |(2000-631.25) |(1368.75)2 |1873477 | |Charming Shoppes |1600 |(1600-631.25) |(968.75)2 |938477 | |Rodale |500 |(500-631.25) |(-131.25)2 |17227 | |Mothers Work |366.3 |(366.3-631.25) |(-264.95)2 |70199 | |Harmelin Media |200 |(200-631.25) |(-431.25)2 |185977 | |McGettigan Partners |175 |(175-631.25) |(-456.25)2 |208164 | |Wetherill Associates |135 |(135-631.25)...