Basic Business Statistics, Student Value Edition
14th Edition
ISBN: 9780134685113
Author: Mark L. Berenson, David M. Levine, David F. Stephan, Kathryn Szabat
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 17, Problem 13PS
The file MobileSpeed contains the overall download and upload speeds in mbps for nine carriers in the United States.
a. Perform a cluster analysis using the complete linkage method on the U.S. carriers based on the download and upload speeds.
b. What conclusions can you reach about which carriers are most similar?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Are Southern and Western states equally prone to fatal lightning strikes? The National Weather Service maintains a database that provides information on lightning strike
fatalities by state. The number of lightning strike fatalities from 2010 to 2014 for Southern and Western states are shown as follows. (National Weather Service website, April
2015). Use Table 1 of Appendix B.
Click on the datafile logo to reference the data.
DATA file
Southern State
Fatalities
Western State
Fatalities
AL
AZ
9.
AR
3
СА
3
FL
17
ID
1
GA
MT
1
KY
NM
1
LA
NV
MS
2
OR
1
NC
4
UT
4
OK
SC
1
WA
WY
TN
TX
8.
VA
Use a .05 and test to determine whether the distribution of lightning fatalities is the same for these two regions.
What is the mean and standard deviation of the normal distribution that can be used for this statistical test?
Mean (to nearest whole number)
4
Standard deviation (to 4 decimals)
3.8439
The file MidCity Download MidCitycontains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood.
Conduct a regression analysis to understand, estimate and interpret the square footage of houses in Mid City. Use one Excel spreadsheet labeled P2 to show your work for this problem.
Home
Nbhd
Offers
Sq Ft
Brick
Bedrooms
Bathrooms
Price
1
2
2
1790
No
2
2
228600
2
2
3
2030
No
4
2
228400
3
2
1
1740
No
3
2
229600
4
2
3
1980
No
3
2
189400
5
2
3
2130
No
3
3
239600
6
1
2
1780
No
3
2
229200
7
3
3
1830
Yes
3
3
303200
8
3
2
2160
No
4
2
301400
9
2
3
2110
No
4
2
238400
10
2
3
1730
No
3
3
208000
11
2
3
2030…
The file MidCity Download MidCitycontains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood.
PROBLEM 1: Construct 3 different confidence intervals.
Part A) Sort and filter the data from the MidCity file so that you only consider the data from neighborhood 1. Construct a 99% confidence interval for the square footage of all homes in neighborhood 1. Make sure you list the specific equations you are using, ALL variables, show ALL work etc., in your report. You can use Excel to complete all computations. Remember to interpret these confidence intervals in the context of this problem. Use one Excel spreadsheet…
Chapter 17 Solutions
Basic Business Statistics, Student Value Edition
Ch. 17 - The business problem facing a consumer products...Ch. 17 - Prob. 2PSCh. 17 - Prob. 3PSCh. 17 - The owner of a moving company typically has his...Ch. 17 - A hotel has designed a new system for room service...Ch. 17 - A marketing manager wants to predict customers...Ch. 17 - An automotive insurance company wants to predict...Ch. 17 - Undergraduate students at Miami University in...Ch. 17 - Prob. 9PSCh. 17 - The file Cereals contains the calories,...
Ch. 17 - The file Protein contain calorie and cholesterol...Ch. 17 - Prob. 12PSCh. 17 - The file MobileSpeed contains the overall download...Ch. 17 - Prob. 14PSCh. 17 - Prob. 15PSCh. 17 - Prob. 16PSCh. 17 - Prob. 17PSCh. 17 - Prob. 18PSCh. 17 - Prob. 19PSCh. 17 - Prob. 20PSCh. 17 - Prob. 21PSCh. 17 - Prob. 22PSCh. 17 - What is the difference between supervised and...Ch. 17 - Prob. 24PSCh. 17 - Prob. 25PSCh. 17 - How does cluster analysis differ from...Ch. 17 - Prob. 27PSCh. 17 - Prob. 28PSCh. 17 - The file FTMBA contains a sample of top-ranked...Ch. 17 - Prob. 30PSCh. 17 - Prob. 31PSCh. 17 - Prob. 32PSCh. 17 - Prob. 33PSCh. 17 - Prob. 34PSCh. 17 - Prob. 35PSCh. 17 - In recent years, the share of Greek yogurts in the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The file MidCity Download MidCitycontains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood. Part A) Do buyers pay a premium for a brick house, all else being equal? Use one Excel spreadsheet labeled Prob3a to show your work for this problem. Part B) Is there a premium for a house in neighborhood 3, all else being equal? Use one Excel spreadsheet labeled Prob3b to show your work for this problem. Home Nbhd Offers Sq Ft Brick Bedrooms Bathrooms Price 1 2 2 1790 No 2 2 228600 2 2 3 2030 No 4 2 228400 3 2 1 1740 No 3 2 229600 4 2 3 1980 No 3 2 189400 5 2 3 2130 No 3 3 239600 6 1 2 1780 No 3 2 229200…arrow_forwardThe file MidCity Download MidCitycontains data on 128 recent sales in Mid City. For each sale, the file shows the neighborhood (1, 2, or 3) in which the house is located, the number of offers made on the house, the square footage, whether the house is made primarily of brick, the number of bathrooms, the number of bedrooms, and the selling price. Neighborhoods 1 and 2 are more traditional neighborhoods, whereas neighborhood 3 is a newer, more prestigious neighborhood. Home Nbhd Offers Sq Ft Brick Bedrooms Bathrooms Price 1 2 2 1790 No 2 2 228600 2 2 3 2030 No 4 2 228400 3 2 1 1740 No 3 2 229600 4 2 3 1980 No 3 2 189400 5 2 3 2130 No 3 3 239600 6 1 2 1780 No 3 2 229200 7 3 3 1830 Yes 3 3 303200 8 3 2 2160 No 4 2 301400 9 2 3 2110 No 4 2 238400 10 2 3 1730 No 3 3 208000 11 2 3 2030 Yes 3 2 265000 12 2 2 1870 Yes 2 2 246000 13 1 4 1910 No 3 2 205200 14 1 5 2150 Yes 3 3 252600 15 3 4 2590 No 4 3 353600 16 3 1 1780 No 4 2 291600 17 2 4 2190 Yes 3 3…arrow_forwardThe Federal Bureau of Investigation (FBI), as part of its internal security mission, serves as a database for all the reported crimes committed in the United States. One question that might be of interest is does having more police officers reduce the number of homicides? To investigate this claim, the 2013 data from the twenty largest municipal cities was supplied by the FBI's Uniform Crime Report. Below are two observations from the dataset: > head (cities) City Pop Homicides Police Density MedHome Mayor 1 New York 8175.133 335 4.2595 27016.30 5.5390 1 2 Chicago 2695.598 414 4.4309 11843.58 1.8310 The variables included in the study are: Name of city Population of city in 1,000s of people Number of homicides in the year 2013 Number of police officers per 1,000 people Number of people per square mile Median home price in $100,000 1 if city has a "Strong Mayor" form of government; 0 if not City Рор Homicides Police Density MedHome Мayor Model: log(u;) = Bo + B1Police; + B2MedHome; +…arrow_forward
- Accounting Today identified top accounting firms in 10 geographic regions across the United States. All 10 regions reported growth in a recent year. The Southeast and Gulf Coast regions reported growths of 12.49% and 9.78%, respectively. A characteristic description of the accounting firms in the Southeast and Gulf Coast regions included the number of partners in the firm. The file [Accounting Partners 2] contains the number of partners. Source: Data extracted from Accounting Today, "The 2019 Top Firms and Regional Leaders," available at bit.ly/2XdQVVW. Number of Partners Region Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Southeast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf Coast Gulf…arrow_forwardMany countries, especially those in Europe, have significant gold holdings. But, many of these countries also have massive debts. The following data show the total value of gold holdings in billions of U.S. dollars and the debt as a percentage of the gross domestic product for nine countries (WordPress and Trading Economics websites, February 24, 2012). Country Gold Value Debt China 63 17.7 France 146 81.7 Germany 203 83.2 Indonesia 33 69.2 Italy 147 119 Netherlands 36 63.7 Russia 50 9.9 Switzerland 62 55 U.S. 487 93.2 c. Using the entire data set, develop the estimated regression equation that can be used to predict the debt of a country given the total value of its gold holdings. d. Use residual analysis to determine whether any outliers or influential observations are present. e. Suppose that after looking at the scatter diagram in part (a) that you were able to visually identify what appears to be an influential observation. Drop this observation…arrow_forwardMany countries, especially those in Europe, have significant gold holdings. But, many of these countries also have massive debts. The following data show the total value of gold holdings in billions of U.S. dollars and the debt as a percentage of the gross domestic product for nine countries (WordPress and Trading Economics websites, February 24, 2012). Country Gold Value Debt China 63 17.7 France 146 81.7 Germany 203 83.2 Indonesia 33 69.2 Italy 147 119 Netherlands 36 63.7 Russia 50 9.9 Switzerland 62 55 U.S. 487 93.2 a. Develop a scatter diagram for the total value of a country’s gold holdings ($ billions) as the independent variable. b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables? Do there appear to be any outliers and/or influential observations? Explain. c. Using the entire data set, develop the estimated regression equation that can be used to predict the debt of a country given the…arrow_forward
- Assume that you work in the Planning Department of LTG National Bank and report to Miss G. You will need to do some data analysis and prepare a short-written report. The written part of the report should not exceed a page in length. Remember, Mr. K is the President of the bank, so you will want to ensure that your report is complete and accurate. A copy of the data appears in page 3. The LTG National Bank has offices in several areas of Metro Manila. Mr. K, President and CEO, would like to know the characteristics of his checking account customers. What is the balance of a typical customer? How many other bank services do the checking account customers use? Do the customers use the ATM service and if so how often? What about debit cards? Who uses them, and how often are they used? To better understand the customers, Mr. K asked Miss G, Director of Planning to select a sample of customers and prepare a report. To begin, she has appointed a team from her staff. You are the head of the…arrow_forwardIn an attempt to asses total daily travel taxes in various cities, the Global Business Travel Association conducted a study of daily travel taxes on lodging, rental cars, and mealsarrow_forwardMany countries, especially those in Europe, have significant gold holdings. But many of these countries also have massive debts. The following data show the total value of gold holdings in billions of U.S. dollars and the debt as a percentage of the gross domestic product for nine countries (WordPress and Trading Economics websites, February 24, 2012). Country Gold Value Debt China 63 17.7 France 146 81.7 Germany 203 83.2 Indonesia 33 69.2 Italy 147 119 Netherlands 36 63.7 Russia 50 9.9 Switzerland 62 55 U.S. 487 93.2 Select for the total value of a country's gold holdings ($ billions) as the independent variable in a scatter diagram. Using the entire data set, develop the estimated regression equation that can be used to predict the debt of a country given the total value of its gold holdings. ^y = ___ (to 4 decimals) + ___ ( to 4 decimals). Gold Value Suppose that after looking at the scatter…arrow_forward
- The International League of Triple-A minor league baseball consists of 14 teams organized into three divisions: North, South, and West. The data showing the average attendance for the 14 teams in the International League are contained in the Excel Online file below. Also shown are the teams’ records; W denotes the number of games won, L denotes the number of games lost, and PCT is the proportion of games played that were won. Construct a spreadsheet to answer the following questions. Team Name Division W L PCT Attendance Buffalo Bisons North 66 77 0.462 8791 Lehigh Valley IronPigs North 55 89 0.382 8454 Pawtucket Red Sox North 85 58 0.594 9080 Rochester Red Wings North 79 70 0.53 6909 Scranton-Wilkes Barre Yankees North 88 56 0.611 7164 Syracuse Chiefs North 69 77 0.473 5749 Charlotte Knights South 68 78 0.466 4545 Durham Bulls South 74 70 0.514 7020 Norfolk Tides South 64 78 0.451 6269 Richmond Braves South 63 79 0.444 4449 Columbus Clippers West 69 73 0.486…arrow_forwardCharity Navigator is America's leading independent charity evaluator. The following data show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities (Charity Navigator website). Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Do not round your intermediate calculations. Total Administrative Fundraising Program Expenses Expenses Expenses Expenses Charity (millions of $) (%) (%) (%) 1 American Red Cross 3350 3.7 3.8 92.0 2 World Vision 1210 3.8 7.8 88.3 3 Smithsonian Institution 1080 23.8 2.3 73.8 4 Food For The Poor 1052 0.7 2.1 96.7 5…arrow_forwardCharity Navigator is America's leading independent charity evaluator. The following data show the total expenses ($), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising, and the percentage spent on program expenses for 10 supersized charities (Charity Navigator website). Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to 100% because of rounding. Do not round your intermediate calculations. Total Administrative Fundraising Program Expenses Expenses Expenses Expenses Charity (millions of $) (%) (%) (%) 1 American Red Cross 3352 3.9 3.9 92.3 2 World Vision 1205 4.1 7.5 88.3 3 Smithsonian Institution 1082 23.4 2.6 73.9 4 Food For The Poor 1048 0.5 2.3 96.9 5…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY