Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
6th Edition
ISBN: 9781337589383
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 58SE
A zoo has categorized its visitors into three categories: member, school, and general. The member category refers to visitors who pay an annual fee to support the zoo. Members receive certain benefits such as discounts on merchandise and trips planned by the zoo. The school category includes faculty and students from day care and elementary and secondary schools; these visitors generally receive a discounted rate. The general category includes all other visitors. The zoo has been concerned about a recent drop in attendance. To help better understand attendance and membership, a zoo staff member has collected the following data:
- a. Construct a bar chart of total attendance over time. Comment on any trend in the data.
- b. Construct a side-by-side bar chart showing attendance by visitor category with year as the variable on the horizontal axis.
- c. Comment on what is happening to zoo attendance based on the charts from parts (a) and (b).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
please do a and c !!!!
Reliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months.
Ad Exp.
Sales Rev.
Month
($ in 000)
($ in 000)
July
2
7
August
1
3
September
3
8
October
4
10
G-9 B continued Questions from G-9
e) Reproduce the excel output manually.
f) Interpret the strength of the correlation coefficient.
g) Determine the coefficient of determination. Interpret.
h) Test the significance of the Coefficient of Correlation
i) Test the significance of the slope coefficients of the regression equation.
Reliable Furniture is a family business that has been selling to retail customers in the Oakville area for many years. It advertises extensively on radio and TV, emphasizing their its prices and easy credit terms. The owner would like to review the relationship between sales and the amount spent on advertising. Below is information on sales and advertising expense for the last four months.
Ad Exp.
Sales Rev.
Month
($ in 000)
($ in 000)
July
2
7
August
1
3
September
3
8
October
4
10
a) Determine the regression equation.
b) Interpret the values of a and b.
c) Estimate sales when $3 thousand is spent on advertising. Include the 95% confidence interval for average X
d) Determine the coefficient of correlation.
Chapter 2 Solutions
Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
Ch. 2.1 - Methods
1. The response to a question has three...Ch. 2.1 - 2. A partial relative frequency distribution is...Ch. 2.1 - A questionnaire provides 58 Yes, 42 No, and 20...Ch. 2.1 -
For the 2010–2011 viewing season, the top five...Ch. 2.1 -
In alphabetical order, the six most common last...Ch. 2.1 - Top Rated Television Show Networks. Nielsen Media...Ch. 2.1 - Airline Customer Satisfaction Survey. Many...Ch. 2.1 - Prob. 8ECh. 2.1 - Prob. 9ECh. 2.1 -
VirtualTourist provides ratings for hotels...
Ch. 2.2 - 11. Consider the following data.
Develop a...Ch. 2.2 - 12. Consider the following frequency...Ch. 2.2 - Construct a histogram for the data in exercise...Ch. 2.2 - Prob. 14ECh. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Construct a stem-and-leaf display for the...Ch. 2.2 - Applications
17. A doctor’s office staff studied...Ch. 2.2 - NBA Total Player Ratings. CBSSports.com developed...Ch. 2.2 - Prob. 19ECh. 2.2 - CEO Time in Meetings. The London School of...Ch. 2.2 - Quantcast.com provides the number of people from...Ch. 2.2 - Top U.S. Franchises. Entrepreneur magazine ranks...Ch. 2.2 - Prob. 24ECh. 2.2 - Best Paying College Degrees. Each year America.EDU...Ch. 2.2 - Prob. 26ECh. 2.3 - The following data are for 30 observations...Ch. 2.3 - The following observations are for two...Ch. 2.3 - Daytona 500 Automobile Makes Average Speeds. The...Ch. 2.3 - Daytona 500 Average Speeds of Winners. The...Ch. 2.3 - 31. Recently, management at Oak Tree Golf Course...Ch. 2.3 - Household Income Levels. The following...Ch. 2.3 - 33. Each year Forbes ranks the world’s most...Ch. 2.3 - Prob. 34ECh. 2.3 -
The U.S. Department of Energy's Fuel Economy...Ch. 2.4 - The following 20 observations are for two...Ch. 2.4 - Prob. 37ECh. 2.4 - The following crosstabulation summarizes the data...Ch. 2.4 - Driving Speed and Fuel Efficiency. A study on...Ch. 2.4 - The DATAfile Snow contains average annual snowfall...Ch. 2.4 - Hypertension and Heart Disease. People often wait...Ch. 2.4 -
Smartphones are mobile phones with Internet,...Ch. 2.4 - Store Managers Time Study. The Northwest regional...Ch. 2 - SAT Scores. The SAT is a standardized test used by...Ch. 2 - Median Household Incomes. The file MedianHousehold...Ch. 2 - State Populations. Data showing the population by...Ch. 2 - Startup Company Funds. According to the Wall...Ch. 2 - Complaints Reported to BBB. Consumer complaints...Ch. 2 - Stock Price Volatility. The term “beta” refers to...Ch. 2 - Education Level and Household Income. The U.S....Ch. 2 - Prob. 51SECh. 2 - Best Places to Work. Fortune magazine publishes an...Ch. 2 - Prob. 53SECh. 2 - Prob. 54SECh. 2 - Prob. 55SECh. 2 - Prob. 56SECh. 2 -
Google has changed its strategy with regard to...Ch. 2 -
A zoo has categorized its visitors into three...Ch. 2 - Pelican Stores, a division of National Clothing,...Ch. 2 -
Motion Picture Industry
The motion picture...Ch. 2 - Cincinnati, Ohio, also known as the Queen City,...Ch. 2 - Jon Weideman, first shift foreman for Cut-Rate...
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
- Suppose the table below gives the average tuition and fees at 2-year and 4-year state schools in a particular state. Values are adjusted to 2019 dollars. Academic Year 4-year state school 2-year state school 2005-06 $5,904 $2,661 2006-07 $6,066 $2,539 2007-08 $6,289 $2,604 2008-09 $7,222 $2,901 2009-10 $7,738 $3,065 2010-11 $8,035 $3,117 2011-12 $8,154 $3,108 2012-13 $8,497 $3,075 2013-14 $8,578 $3,025 2014-15 $9,390 $3,326 2015-16 $10,004 $3,504 2016-17 $10,474 $3,663 2017-18 $10,789 $3,830 2018-19 $10,874 $3,859 2019-20 $10,900 $3,907 Here is a graph of the information from the table. a. What is the absolute change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? b. What is the relative change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? Round to the nearest whole percentage…arrow_forwardCompare and contrast the three types of responsibility centers. What is the best way to evaluate a manager's performance in each type of center? What is the problem with using only financial measures of performance?arrow_forwardThe monthly cost for health care for an employee and two dependents in a certain year is given in the following table. Provider Cost Provider Cost Maxicare $415.31 Kaiser $4337 Cigna $424.74 Aetna $436.26 Health Net $427.29 Blue Shield $442.25 Pacific Care $428.06 Omni Healthcare $457.90 Redwoods Plan $431.53 Lifeguard $457.64 Draw a box plot for the monthly costs of health care (ranked from lowest to highest). 0415 420 425 430 435 440 0425 430 435 440 445 450 455 420 430 440 450 420 430 440 450arrow_forward
- Many organizations offer "special" magazine subscription rates to their members. The American Federation of Teachers is no different, and here are a few of the rates they offer their members. Magazine SS(y) SS(xy) Usual Rate Your Price $29.20 Cosmopolitan Sports Illustrated $78.20 Ebony $20.75 Rolling Stone $23.05 Martha Stewart Living $25.25 $17.85 $39.80 $15.95 $12.05 $19.75 (a) Construct a scatter diagram with "Your Price" as the dependent variable, y, and "Usual Rate" as the independent variable, x. (Do this diagram on paper. Your instructor may ask you to turn this in.) (b) Find SS(x), SS(y), and SS(xy). (Enter your answers to two decimal places.) SS(x) (c) Find Pearson's product moment, r. (Enter your answer to three decimal places.)arrow_forwardPlease help with homeworkarrow_forwardIn 2011, home prices and mortgage rates fell so far that in a number of cities the monthly cost of owning a home was less expensive than renting. The following data show the average asking rent and the monthly mortgage on the median-priced home (including taxes and insurance) for 10 cities where the average monthly mortgage payment was less than the average asking rent (The Wall Street Journal, November 26–27, 2011). 7. City Rent ($) Mortgage ($) Atlanta 840 539 1062 1002 Chicago Detroit 823 626 DATA file Jacksonville, Fla. Las Vegas 779 711 796 655 RentMortgage 1071 953 Miami 977 Minneapolis Orlando, Fla. 776 851 695 762 651 654 Phoenix St. Louis 723 Develop a scatter diagram for these data, treating the average asking rent as the inde- pendent variable. Does a simple linear regression model appear to be appropriate? b. Use a simple linear regression model to develop an estimated regression equation to predict the monthly mortgage on the median-priced home given the average asking…arrow_forward
- Bargain Rental Car wants to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility that cleans each rental car before releasing it to another customer. Management believes the variable portion of its car washing costs relates to the number of rental returns. Accordingly, the following data have been compiled: Month January February March April May June July August September October November December Rental Returns 2,400 2,500 2,800 3,100 3,700 5,100 5,600 5,600 Fixed cost per month Variable cost per rental return 4,700 4,100 2,200 2,900 Exercise 5A-2 Part 2 (Algo) Car Wash Costs $ 11,300 $ 13,300 $ 12,100 $ 14,700 $ 16,500 $ 23,900 $ 22,500 $ 22,900 $ 23,100 $ 22,000 $ 11,000 $ 15,300 2. Using least-squares regression, estimate the variable cost per rental return and the monthly fixed cost incurred to wash cars. Note: Round Fixed cost to the nearest whole dollar amount and the Variable cost per unit to 2 decimal…arrow_forwardMedicare's new medical plans offer a wide range of variations and choices for seniors when picking a drug plan. The monthly cost for a stand-alone drug plan varies from plan to plan and from state to state. The accompanying table gives the premium for the plan with the lowest cost for each state. State Cost per Month (dollars) Alabama 3.84 Alaska 1.87 Arizona 13.87 Arkansas 8.26 California 19.88 Colorado 10.63 Connecticut 4.34 Delaware 6.29 District of Columbia 7.01 Florida 17.73 Georgia 12.39 Hawaii 6.22 Idaho 9.73 Illinois 20.86 Indiana 3.28 Iowa 8.86 Kansas 1.87 Kentucky 8.75 Louisiana 9.65 Maine 1.87 Maryland 6.78 Massachusetts 10.68 Michigan 17.59 Minnesota 8.99 Mississippi 9.60 Missouri 10.10 Montana 10.13 Nebraska 10.33 Nevada 1.87 New Hampshire 10.00 New Jersey 13.92 New Mexico 8.87 New York 13.17 North Carolina 17.90 North Dakota 12.55 Ohio 1.87 Oklahoma 6.41 Oregon 1.87 Pennsylvania 15.68…arrow_forwardMedicare's new medical plans offer a wide range of variations and choices for seniors when picking a drug plan. The monthly cost for a stand-alone drug plan varies from plan to plan and from state to state. The accompanying table gives the premium for the plan with the lowest cost for each state. State Cost per Month (dollars) Alabama 7.50 Alaska 1.87 Arizona 6.22 Arkansas 13.42 California 7.97 Colorado 16.38 Connecticut 10.53 Delaware 1.87 District of Columbia 7.74 Florida 6.03 Georgia 15.29 Hawaii 5.05 Idaho 15.21 Illinois 14.31 Indiana 8.40 Iowa 13.57 Kansas 9.30 Kentucky 6.24 Louisiana 5.21 Maine 13.24 Maryland 6.66 Massachusetts 9.95 Michigan 6.59 Minnesota 1.87 Mississippi 1.87 Missouri 12.68 Montana 19.69 Nebraska 9.95 Nevada 17.29 New Hampshire 6.67 New Jersey 18.36 New Mexico 6.85 New York 1.87 North Carolina 12.34 North Dakota 9.50 Ohio 19.25 Oklahoma 8.33 Oregon 6.87 Pennsylvania 1.87 Rhode…arrow_forward
- The following table shows the expenses and income for a local college student. Assume that amounts shown for salaries and wages are after taxes and that 1 month = 4 weeks. Income Expenses Part-time Job: $1100/month Rent: $550/month Student Loans: $8400/year Groceries: $50/week Scholarship: $5700/year Tuition and Fees: $7500/year Health Insurance: $40/month Entertainment: $40/week Phone: $65/month a) What is the student's monthly income? b) What is the student's monthly expenses? c) What is the student's net monthly cash flow?arrow_forwardThe percentage of employees who cease their employment during a year is referred to as employee turnover, and it is a serious issue for businesses. The following table shows the cost, in millions of dollars, to a certain company for a given employee turnover percentage in a year.arrow_forwardThe asking price (in thousands of dollars) of some four-bedroom homes in a certain city are described by the dotplot. Asking Prices of Four-Bedroom Homes .. 50 100 150 200 250 300 350 400 450 Thousands of dollars Complete parts (a) through (e). a. A buyer can afford to pay up to $350 thousand. Assuming sellers will not lower their asking prices, what proportion of the homes can the buyer afford? The proportion of homes that the buyer can afford is 0.939. (Round to the nearest thousandth as needed.) b. What proportion of the homes have asking prices between $150 thousand and $250 thousand? The proportion of homes with asking prices between $150 thousand and $250 thousand is (Round to the nearest thousandth as needed.) c. If there were two outliers, estimate their values. The values of the outliers are thousand and V thousand. d. It turns out that the two homes with asking prices you identified in part (c) also have square footages that are outliers. Why does this make sense? O A. This…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Use of ALGEBRA in REAL LIFE; Author: Fast and Easy Maths !;https://www.youtube.com/watch?v=9_PbWFpvkDc;License: Standard YouTube License, CC-BY
Compound Interest Formula Explained, Investment, Monthly & Continuously, Word Problems, Algebra; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=P182Abv3fOk;License: Standard YouTube License, CC-BY
Applications of Algebra (Digit, Age, Work, Clock, Mixture and Rate Problems); Author: EngineerProf PH;https://www.youtube.com/watch?v=Y8aJ_wYCS2g;License: Standard YouTube License, CC-BY