Assignment 1 – Task 1
Refer to the data set in Table 1.7 as shown below:
Excel File: data01-05.xls
a. What is the average price for the cordless telephones (to 2 decimals)?
A) 68.12
b. What is the average talk time for the cordless telephones (to 3 decimals)?
hours
A)8.875
c. What percentage of the cordless telephones have a voice quality of excellent?
A) 25
d. What percentage of the cordless telephones have a handset on the base?
A) 50
Assignment 1 – Task 2
Exercise 01.07
The Kroger Company is one of the largest grocery retailers in the United States, with over 2000 grocery stores across the country. Kroger uses an online customer opinion questionnaire to obtain performance data about its products and services and learn about what motivates its customers (Kroger website, April 2012). In the survey, Kroger customers were asked if they would be willing to pay more for products that had each of the following four characteristics. The four questions were: Would you pay more for
products that have a brand name?
products that are environmentally friendly?
products that are organic?
products that have been recommended by others?
For each question, the customers had the option of responding yes if they would pay more or no if they would not pay more.
a. Is the data collected by Kroger in this example categorical or quantitative?
A) Categorical
b. What measurement scale is used?
A) Nominal
Assignment 1 – Task 3
Exercise 01.09
The Commerce Department reported receiving the following applications for the Malcolm Baldrige National Quality Award: 23 from large manufacturing firms, 18 from large service firms, and 30 from small businesses.
a. Is type of business a categorical or quantitative variable?
A) Quantitative
b. What percentage of the applications came from small businesses (to 1 decimal)?
A) 42.2
Assignment 1 – Task 4
Exercise 01.11
In a gallup telephone survey conducted on April 9–10, 2013, the person being interviewed was asked if he would vote for a law in his state that would increase the gas tax up to 20 cents a gallon, with the new gas tax money going to improve roads and bridges and build more mass transportation in his state. Possible responses were vote for, vote against, and no opinion. Two hundred ninety five respondents said they would vote for the law, 672 said they would vote against the law, and 51 said they had no opinion (gallup website, June 14, 2013).
a. Do the responses for this question provide categorical or quantitative data?
A) Categorical
b. What was the sample size for this gallup poll?
A) 1018
c. What percentage of respondents would vote for a law increasing the gas tax (to the nearest whole number)?
A) 29
d. Do the results indicate general support for or against increasing the gas tax to improve roads and bridges and build more mass transportation?
A) support against
Assignment 1 – Task 5
Exercise 01.21
A seven-year medical research study reported that women whose mothers took the drug DES during pregnancy were twice as likely to develop tissue abnormalities that might lead to cancer as were women whose mothers did not take the drug.
a. This study compared two populations. What were the populations?
A) Women whose mothers took DES during pregnancy and women whose mothers did not
c. For the population of women whose mothers took the drug DES during pregnancy, a sample of 3980 women showed that 63 developed tissue abnormalities that might lead to cancer. Provide a descriptive statistic (to 1 decimal) that could be used to estimate the number of women out of 1,000 in this population who have tissue abnormalities. 15.8 out of 1,000 women developed tissue abnormalities
d. For the population of women whose mothers did not take the drug DES during pregnancy, what is the estimate (to 1 decimal) of the number of women out of 1,000 who would be expected to have tissue abnormalities? (Hint: remember that women whose mothers took the drug were twice as likely to develop tissue abnormalities.) 7.9 out of 1,000 women developed tissue abnormalities.
e. True or false: medical studies often use a relatively large sample (in this case, 3980) because disease occurrences can be rare and difficult to observe when only isolated populations are considered.
True
Assignment 1 – Task 6
Exercise 01.23
Pew Research Center is a nonpartisan polling organization that provides information about issues, attitudes, and trends shaping America. In a poll, Pew researchers found that 47% of American adult respondents reported getting at least some local news on their cell phone or tablet computer (Pew Research website, May 14, 2011). Further findings showed that 42% of respondents who own cell phones or tablet computers use those devices to check local weather reports and 37% use the devices to find local restaurants or other businesses.
a. One statistic concerned using cell phones or tablet computers for local news. What population is that finding applicable to?
All American adults
b. Another statistic concerned using cell phones or tablet computers to check local weather reports and to find local restaurants. What population is this finding applicable to?
American adults that own a cellphone and/or a tablet computer
c. Do you think the Pew researchers conducted a census or a sample survey to obtain their results? Why?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
A survey was conducted. Unless a survey is conducted and analysed it is not possible to collect details in percentages. the survey is conducted to collect categorical values and base on the results the average percentage of adults and their mobile use to find news and restaurants was evaluated
d. If you were a restaurant owner, would you find these results interesting? Why? How could you take advantage of this information?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
Yes. It is because if customers searching for restaurant information it mean that people like my restaurant. To encourage such competitive advantage i will keep better details about the restaurant on online such that customers efforts to find my restaurant is reduced,
Assignment 1 – Task 7
The following table shows a data set containing information for 25 of the shadow stocks tracked by the American Association of Individual Investors (aaii.com, February 2002). Shadow stocks are common stocks of smaller companies that are not closely followed by Wall Street analysts.
Click on the datafile logo to reference the data.
a. How many variables are in the data set?
A) 5
b. Of the following subset of variables, indicate which are categorical and which are quantitative.
A)
| Exchange | Categorical |
| Price/Earnings Ratio | Quantitative |
| Gross Profit Margin (%) | Quantitative |
c.
d. For the Exchange variable, show the frequency and the percent frequency for AMEX, NYSE, and OTC.
| AMEX | 5 | 20 |
| NYSE | 3 | 12 |
| OTC | 17 | 68 |
| Total | 25 | 100 |
e. Choose the correct bar graph from the above diagrams:
A) A
Show the frequency distribution for the Gross Profit Margin using the five intervals below:
0–14.9, 15–29.9, 30–44.9, 45–59.9, and 60–74.9
| Gross Profit Margin | Frequency | |||
| 0 | – | 14.9 | 2 | |
| 15 | – | 29.9 | 6 | |
| 30 | – | 44.9 | 8 | |
| 45 | – | 59.9 | 6 | |
| 60 | – | 74.9 | 3 | |
i. Choose the correct histogram from the above diagrams:
A) A
j. What is the average price/earnings ratio (to 1 decimal)?
A) 20.2
Assignment 2 – Task 1
Exercise 02.01 Algorithmic
The response to a question has three alternatives: A, B, and C. A sample of 120 responses provides 64 A, 23 B, and 33 C responses. Show the frequency and relative frequency distributions (use nearest whole number for the frequency column and 2 decimal for the relative frequency column).
| Class | Frequency | Relative Frequency |
| A | 64 | 0.53 |
| B | 23 | 0.19 |
| C | 33 | 0.27 |
| (Total) | 120 | 1 |
Assignment 2 – Task 2
Exercise 02.05
In alphabetical order, the six most common last names in the United States are Brown, Johnson, Jones, Miller, Smith, and Williams (The World Almanac, 2012). Assume that a sample of 50 individuals with one of these last names provided the following data.
Summarize the data by constructing the following items.
a. Fill in the frequency (to the nearest whole number) and the relative frequency (to 2 decimals) values below.
| Name | Frequency | Relative Frequency |
| Brown | 7 | 0.14 |
| Johnson | 10 | 0.20 |
| Jones | 7 | 0.14 |
| Miller | 6 | 0.12 |
| Smith | 12 | 0.24 |
| Williams | 8 | 0.16 |
| (Total) | 50 | 1 |
b. Which of the following three bar graphs accurately represents the data?
A) 1
c. Select the correct pie chart from the following.
A) 1
d. Based on these data, what are the three most common last names?
A) Smith, Johnson, and Williams
Assignment 2 – Task 3
Exercise 02.11
Consider the following data.
Summarize the data by filling in the frequency (to the nearest whole number), the relative frequency (3 decimals), and the percent frequency (1 decimal) values below.
| Class | Frequency | Relative Frequency | Percent Frequency |
| 12-14 | 2 | 0.05 | 5 |
| 15-17 | 8 | 0.20 | 20 |
| 18-20 | 11 | 0.27 | 27.5 |
| 21-23 | 10 | 0.25 | 25 |
| 24-26 | 9 | 0.22 | 22.5 |
| (Total) | 40 | 1 | 100 |
Assignment 2 – Task 4
| Each year America.EDU ranks the best paying college degrees in America. The following data show the median starting salary, the mid-career salary, and the percentage increase from starting salary to mid-career salary for the 20 college degrees with the highest mid-career salary (America.EDU website, August 29, 2013). Click on the datafile logo to reference the data. a. Using a class width of 10, select a histogram for the percentage increase in the starting salary. A) Histogram 2 b. Comment on the shape of the distribution. The histogram is slightly skewed to the right c. Develop a stem-and-leaf display for the percentage increase in the starting salary. If answer is zero enter “0”. |
| 4 | 3 | ||||||
| 5 | |||||||
| 6 | 1 | 3 | 7 | 9 | |||
| 7 | 1 | 3 | 4 | 5 | 7 | 7 | 9 |
| 8 | 2 | 4 | 7 | ||||
| 9 | 0 | 3 | 6 | ||||
| 10 | 0 | ||||||
| 11 | 3 |
d. What are the primary advantages of the stem-and-leaf display as compared to the histogram?
easier to construct by hand and provides more information than the histogram
Assignment 2 – Task 5
Exercise 02.31
Recently, management at Oak Tree Golf Course received a few complaints about the condition of the greens. Several players complained that the greens are too fast. Rather than react to the comments of just a few, the Golf Association conducted a survey of 100 male and 100 female golfers. The survey results are summarized here.
| Male Golfers | ||
| Greens Condition | ||
| Handicap | Too Fast | Fine |
| Under 15 | 10 | 40 |
| 15 or more | 25 | 25 |
| Female Golfers | ||
| Greens Condition | ||
| Handicap | Too Fast | Fine |
| Under 15 | 1 | 9 |
| 15 or more | 39 | 51 |
a. Complete the crosstabulation shown below.
| Green Condition | |||
| Gender | Too Fast | Fine | Total |
| Male | 35 | 65 | 100 |
| Female | 40 | 60 | 100 |
| Total | 75 | 125 | 200 |
b. Which group shows the highest percentage saying that the greens are too fast?
A) Females, at 40%
c. Refer to the initial crosstabulations. For those players with low handicaps (better players), which group (male or female) shows the highest percentage saying the greens are too fast?
For the low handicappers, the Men have a higher percentage who think the greens are too fast.
d. Refer to the initial crosstabulations. For those players with higher handicaps, which group (male or female) shows the highest percentage saying the greens are too fast? For the high handicappers, the Menhave a higher percentage who think the greens are too fast.
e. At each handicap level, how does the percentage of women who think the greens are too fast compare to the percentage of men who feel the same?
A) It is smaller than that of the men
When the crosstabulations are aggregated across handicap level, do you still conclude the same thing when comparing the percentage of women who complain that the greens are too fast with the percentage of the men who feel the same?
A) NO
Assignment 2 – Task 6
A study on driving speed (miles per hour) and fuel efficiency (miles per gallon) for midsize automobiles resulted in the following data:
Click on the datafile logo to reference the data.
a. Which of the following is a scatter diagram with driving speed on the horizontal axis and fuel efficiency on the vertical axis.
Choose the correct scatter diagram from the above diagrams:
A) 1
b. Comment on any apparent relationship between these two variables.
A) Considering the scattered plot it is learned that there exist negative correlation between the two variables
Assignment 2 – Task 7
Google has changed its strategy with regard to how much and over which media it invests in advertising. The following table shows Google’s marketing budget in millions of dollars for 2008 and 2011 (The Wall Street Journal, March 27, 2012).
| 2008 | 2011 | |||
| Internet | $26.0 | $123.3 | ||
| Newspaper, etc. | $4.0 | $20.7 | ||
| Television | $0.0 | $69.3 | ||
a. Select a side-by-side bar chart with year as the variable on the horizontal axis.
A) 1
b. Convert the above table to percentage allocation for each year. Round your answers to one decimal place, if necessary. If your answer is zero, enter “0”.
| 2008 | 2011 | |||
| Internet | $26.0 | $123.3 | ||
| Newspaper, etc. | $4.0 | $20.7 | ||
| Television | $0.0 | $69.3 | ||
Select a stacked bar chart with year as the variable on the horizontal axis.
A) 1
c. Is the display in part (a) or part (b) more insightful? Explain.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
yes, it is very insightful. Using such information it s possible know about the distribution visually.
The response to a question has three alternatives: A, B, and C. A sample of 120 responses provides 59 A, 25 B, and 36 C responses. Show the frequency and relative frequency distributions (use nearest whole number for the frequency column and 2 decimal for the relative frequency column).
| Class | Frequency | Relative Frequency |
| A | 59 | 0.49 |
| B | 25 | 0.21 |
| C | 36 | 0.30 |
| (Total) | 120 | 1 |
Assignment 3 – Task 1
Consider a sample with data values of 10, 20, 12, 17, and 16.
Compute the mean.
15
Compute the median.
16
Assignment 3 – Task 2
Exercise 03.09
Which companies spend the most money on advertising? Business Insider maintains a list of the top-spending companies. In 2014, Procter & Gamble spent more than any other company, a whopping $5 billion. In second place was Comcast, which spent $3.08 billion (Business Insider website, December 2014). The top 12 companies and the amount each spent on advertising in billions of dollars are as follows.
Click on the datafile logo to reference the data.
a. What is the mean amount spent on advertising? (to 2 decimals)
2.55
b. What is the median amount spent on advertising? (to 3 decimals)
2.265
c. What are the first and third quartiles?
First Quartiles (to 1 decimals) 2.
Third Quartiles (to 4 decimals) 2.8225
Assignment 3 – Task 3
Exercise 03.23
Consider a sample with data values of 10, 20, 12, 17, and 16.
Compute the range.
10
Compute the interquartile range (to 1 decimal).
7.5
Assignment 3 – Task 4
Exercise 03.27
The results of a search to find the least expensive round-trip flights to Atlanta and Salt Lake City from 14 major U.S. cities are shown in the following table. The departure date was June 20, 2012 and the return date was June 27, 2012.
Click on the datafile logo to reference the data.
a. Compute the mean price for a round-trip flight into Atlanta and the mean price for a round-trip flight into Salt Lake City. Round your answers to two decimal places.
| Atlanta | 356.73 |
| Salt Lake City | 400.95 |
Is Atlanta less expensive to fly into than Salt Lake City?
yes
If so, what could explain this difference?
IT IS BETTER TO USE ATLANTA ROUTE
b. Compute the range (Round your answers to one decimal place), variance, and standard deviation (Round your answers to two decimal places) for the two samples.
Atlanta Salt Lake City
| Range | $ 290.0 | $ 458.8 |
| Variance | 5517.41 | 18933.32 |
| Standard Deviation | $ 74.28 | $ 137.6 |
What does this information tell you about the prices for flights into these two cities?
The prices for round-trip flights into Atlanta are less variable than prices for round-trip flights into Salt Lake City.
Assignment 3 – Task 5
Consider a sample with data values of 10, 20, 12, 17, and 16. Compute the z-score for each of the five observations. If required enter negative values as negative numbers (to 2 decimals).
Observed value z-score
10 -1.25
20 1.25
12 -0.75
17 0.5
16 0.25
Assignment 3 – Task 6
The Graduate Management Admission Test (GMAT) is a standardized exam used by many universities as part of the assessment for admission to graduate study in business. The average GMAT score is 547 (Magoosh website, January 5, 2015). Assume that GMAT scores are bell-shaped with a standard deviation of 100. Make sure to use the empirical rule to answer these questions.
a. What percentage of GMAT scores are 647 or higher?
16
b. What percentage of GMAT scores are 747 or higher (to 1 decimal)?
2.5
c. What percentage of GMAT scores are between 447 and 547?
34
d. What percentage of GMAT scores are between 347 and 647 (to 1 decimal)?
81.5
Assignment 3 – Task 7
Exercise 03.45
The Wall Street Journal reported that Walmart Stores Inc. is planning to lay off 2,300 employees at its Sam’s Club warehouse unit. Approximately half of the layoffs will be hourly employees (The Wall Street Journal, January 25-26, 2014). Suppose the following data represent the percentage of hourly employees laid off for 15 Sam’s Club stores.
| 55 | 56 | 44 | 43 | 44 | 56 | 60 | 62 | 57 | 45 | 36 | 38 | 50 | 69 | 65 |
a. Compute the mean and median percentage of hourly employees being laid off at these stores.
| Mean | 52 |
| Median | 55 |
b. Compute the first and third quartiles.
| First quartile | 44 |
| Third quartile | 60 |
c. Compute the range and interquartile range.
| Range | 33 |
| Interquartile range | 16 |
d. Compute the variance and standard deviation. Round your answers to four decimal places.
| Variance | 100.1429 |
| Standard deviation | 10.0071 |
e. Do the data contain any outliers?
No
f. Based on the sample data, does it appear that Walmart is meeting its goal for reducing the number of hourly employees?
– Yes
Assignment 3 – Task 8
Exercise 03.47
consider the following data values: 27, 25, 20, 15, 30, 34, 28, and 25.
Which box plot most accurately represents these data?
Box plot #2
Assignment 3 – Task 9
Ten major college football bowl games were played in January 2010, with the University of Alabama beating the University of Texas 37 to 21 to become the national champion of college football. The results of the ten bowl games are shown below (USA Today, January 8, 2010). The predicted winning point margin was based on Las Vegas betting odds approximately one week before the bowl games were played. For example, Auburn was predicted to beat Northwestern in the Outback Bowl by five points. The actual winning point margin for Auburn was three points. A negative predicted winning point margin means that the team that won the bowl game was an underdog and expected to lose. For example, in the Rose Bowl, Ohio State was a two-point underdog to Oregon and ended up winning by nine points.
Click on the datafile logo to reference the data.
a. Select a scatter diagram with predicted point margin on the horizontal axis.
A
b. What is the relationship between predicted and actual point margins?
Positive relationship
c. Compute the sample covariance. Round your answer to four decimal places.
22.3333
Interpret the sample covariance.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
It is positive variance exist between two variables that are considered. when x varies target factor y changes by 22.33 times
d. Compute the sample correlation coefficient. Round your answer to three decimal places.
0.565
What does this value indicate about the relationship between the Las Vegas predicted point margin and the actual point margin in college football bowl games?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.
correlation coefficient is greater than zero it indicates positive correlation
Assignment 3 – Task 10
Exercise 03.61
A random sample of 30 colleges from Kiplinger’s list of the best values in private college provided the data shown in the DATAfile named BestPrivateColleges (Kiplinger, October 2013). The variable named Admit Rate (%) shows the percentage of students that applied to the college and were admitted, and the variable named 4-yr Grad. Rate (%) shows the percentage of students that were admitted and graduated in four years.
Click on the datafile logo to reference the data.
a. Select a scatter diagram with Admit Rate (%) as the independent variable.
Scatter diagram 1
What does the scatter diagram indicate about the relationship between the two variables?
Negative linear Relationship
b. Compute the sample correlation coefficient. Round your answer to two decimal places and enter negative values as negative numbers, if necessary.
-0.76
What does the value of the sample correlation coefficient indicate about the relationship between the Admit Rate (%) and the 4-yr Grad. Rate (%)?
Negative linear Relationship
Other Links:
See other websites for quiz:
Check on QUIZLET