BASIC BUSINESS STATISTICS-STUD.SOLN.MAN
14th Edition
ISBN: 9780134685045
Author: BERENSON
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 36PS
a.
To determine
Find the regression coefficients
b.
To determine
Determine the monthly warehouse distribution cost if the number of orders is 4,500.
c.
To determine
Plot the residual versus time plot.
d.
To determine
Calculate the Durbin-Watson statistic.
To determine
Conclude whether there is evidence that there exists a positive autocorrelation among the residuals.
e.
To determine
Discuss whether there is any reason to question the validity of the model based on the results.
f.
To determine
Determine the conclusions that can be drawn regarding the factors that affect distribution costs.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A mail-order catalog business that sells personal computer supplies, software, and hardware maintains a centralized warehouse for the distribution of products ordered. Management is currently examining the process of distribution from the warehouse and has the business objective of determining the factors that affect warehouse distribution costs. Currently, a handling fee is added to the order, regardless of the amount of the order. Data that indicate the warehouse distribution costs and the number of orders received have been collected over the past 24 months and can be seen below:
Months
Distribution Cost ($thousands)
Number of Orders
1
52.95
4015
2
71.66
3806
3
85.58
5309
4
63.69
4262
5
72.81
4296
6
68.44
4097
7
52.46
3213
8
70.77
4809
9
82.03
5237
10
74.39
4732
11
70.84
4413
12
54.08
2921
13
62.98
3977
14
72.30
4428
15
58.99
3964
16
79.38
4582…
Charity 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…
Charity 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…
Chapter 13 Solutions
BASIC BUSINESS STATISTICS-STUD.SOLN.MAN
Ch. 13 - Prob. 1PSCh. 13 - If the values of X in Problem 13.1 from 2 to 25,...Ch. 13 - Fitting a straight line to a set data yields the...Ch. 13 - The production of wine is a multibillion-dollar...Ch. 13 - Zagat’s publisher restaurant rating for various...Ch. 13 - Is an MBA a golden ticket? Pursuing an MBA is a...Ch. 13 - Starbucks Coffee Co. uses a data-based approach to...Ch. 13 - The value of a sports franchise is directly...Ch. 13 - An agent for a residential real estate company in...Ch. 13 - A box office analyst seeks to predict opening...
Ch. 13 - How do you interpret a coefficient by of...Ch. 13 - If SSR= 36 and SSE=4, determine SST and then...Ch. 13 - If SSR=66 and SST=88, Compute the coefficient of...Ch. 13 - If SSE= 10 and SSR=30, compute the coefficient of...Ch. 13 - If SSR=120, Why is it impossible for SST to equal...Ch. 13 - In problem 13.4 on page 493, the percentage of...Ch. 13 - In problem 13.5 on page 493, you used the summated...Ch. 13 - In Problem 13.6 on page 494, a prospective MBA...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - In problem 13.8 on page 494, you used annual...Ch. 13 - In problem 13.9 on page 494, an agent for a real...Ch. 13 - In problem 13.10 on page 494, you used You tube...Ch. 13 - The following results provide the X Values,...Ch. 13 - The following results show the X Values,...Ch. 13 - In problem 13.5 on page 493, you used the summated...Ch. 13 - In problem 13.4 on page 493, you used the...Ch. 13 - In problem 13.7 on page 494, you used the plate...Ch. 13 - In problem 13.6 on page 494, a prospective MBA...Ch. 13 - In problem 13.9 on page 494, an agent for a real...Ch. 13 - Prob. 30PSCh. 13 - Prob. 31PSCh. 13 - The residuals for 10 consecutive time periods are...Ch. 13 - The residuals for 15 consecutive time periods are...Ch. 13 - In Problem 13.7 on page 494 concerning the...Ch. 13 - What is the relationship between the price of...Ch. 13 - Prob. 36PSCh. 13 - A freshly brewed shot of espresso has three...Ch. 13 - The owners of a chain of ice cream stores have the...Ch. 13 - You are testing the null hypothesis that there is...Ch. 13 - Prob. 40PSCh. 13 - Prob. 41PSCh. 13 - In problem 13.4 on page 493, you used the...Ch. 13 - Prob. 43PSCh. 13 - In problem 13.6 on page 494, a prospective MBA...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - Prob. 46PSCh. 13 - In Problem 13.9 on page 494, an agent for a real...Ch. 13 - In Problem 13.10 on page 494, you used you used...Ch. 13 - The volatility of a stock is often measured by its...Ch. 13 - Prob. 50PSCh. 13 - Prob. 51PSCh. 13 - Movie companies need to predict the gross receipts...Ch. 13 - Prob. 53PSCh. 13 - Prob. 54PSCh. 13 - Prob. 55PSCh. 13 - Based on a sample of n=20, the latest-squares...Ch. 13 - Prob. 57PSCh. 13 - In Problem 13.4 on page 493, you used the...Ch. 13 - In Problem 13.7 on page 494, you used the plate...Ch. 13 - In Problem 13.6 on page 494, a prospective MBA...Ch. 13 - Prob. 61PSCh. 13 - Prob. 62PSCh. 13 - In problem 13.10 on page 494, you used YouTube...Ch. 13 - Prob. 64PSCh. 13 - Prob. 65PSCh. 13 - When is the unexplained variation (i.e., error sum...Ch. 13 - Prob. 67PSCh. 13 - Prob. 68PSCh. 13 - Prob. 69PSCh. 13 - How do you evaluate the assumptions of regression...Ch. 13 - When and how do you use the Durbin-Watson...Ch. 13 - Prob. 72PSCh. 13 - Can you use movie critics’ opinions to forecast...Ch. 13 - Management of a soft-drink botting company has the...Ch. 13 - Measuring the height of a California redwood tree...Ch. 13 - You want to develop a model to predict the asking...Ch. 13 - You want to develop a model to predict the taxes...Ch. 13 - An analyst has the objective of predicting the...Ch. 13 - An accountant for a large department store has the...Ch. 13 - On January 28, 1986, the space shuttle Challenger...Ch. 13 - A baseball analyst would like to study various...Ch. 13 - Can you use the annual revenues generated by...Ch. 13 - In Problem 13.82 you used annual revenue to...Ch. 13 - During the fall harvest season in the United...Ch. 13 - Refer to the discussion of beta values and market...Ch. 13 - The file CEO 2016 includes the total compensation...Ch. 13 - In Problem 13.8, 13.20, 13.30, 13.46, 13.62,...
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
- Charity 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. Charity Total Administrative Fundraising Program Expenses Expenses Expenses Expenses (millions of $) (%) Fundraising Program 1 American Red Cross 3352 3.9 3.9 92.2 2 World Vision 1210 3.8 7.8 88.6 3 Smithsonian Institution 1082 23.5 2.6 73.6 4 Food For…arrow_forwardSpring is a peak time for selling houses. Suppose the data below contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018. Selling Price Baths Sq Ft Selling Price 160,000 170,000 178,000 182,500 195,100 212,500 245,900 250,000 255,000 258,000 267,000 268,000 275,000 1.5 1,786 2 1,768 1 1,219 1 1,578 1.5 1,125 2 1,196 2 2,128 N W 3 2 1,280 1,596 3.5 2,374 2.5 2,439 2 1,470 2 1,688 Beds 3 3 3 2 3 2 3 3 3 4 3 4 4 295,000 325,000 325,000 328,400 331,000 344,500 365,000 385,000 395,000 399,000 430,000 430,000 454,000 Baths Sq Ft 2.5 1,860 3 2,056 3.5 2,776 2 1,408 1.5 1,972 2.5 1,736 2.5 1,990 2.5 3,640 2.5 1,928 2 2,108 2 2,462 2 2,615 3.5 3,700 Beds 3 4 4 4 3 3 4 4 4 3 4 4 4 Consider the estimated regression equation we developed that can be used to predict the selling price given the number of bathrooms, square footage, and number of bedrooms in the house. (x, denotes number of bathrooms, x₂ denotes…arrow_forwardPrices and mileage of 30 Subaru Forester models within 50 miles of Columbus, Indiana are collected from Cargarus.com. Mileage ranged from 7,442 to 77,674 miles. Prices ranged from $25,560 to $29,990. Attached file.arrow_forward
- In 2011 home prices and mortgage rates dropped so low 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 for 10 markets 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).Click on the datafile logo to reference the data. Enter negative values as negative numbers. a. Develop the estimated regression equation that can be used to predict the monthly mortgage given the average asking rent (to 2 decimals).The regression equation is:Mortgage ($) = + Rent ($)arrow_forwardCost of Direct Materials Used in Production for a Manufacturing Company Walker Manufacturing Company reported the following materials data for the month ending June 30: Materials purchased $215,500 Materials inventory, June 1 68,000 Materials inventory, June 30 56,700 Determine the cost of direct materials used in production by Walker during the month ended June 30.arrow_forwardA car dealership keeps track of how much it spends on advertising each month and of its monthly revenue. From this information, the list of advertising expenditures and probable associated revenues are shown in the table below.arrow_forward
- Compare 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_forwardAn economic organization tracks summary statistics of various countries. These include GDP (gross domestic product per capita) and trade balances (measured as a percentage of GDP). Exporting countries tend to have large positive trade balances. Importers have negative balances. The data are shown in the accompanying table. Formulate the SRM with GDP as the response and Trade Balance as the explanatory variable. Complete parts (a) through (c) below. Click the icon to view the data table. (a) Country X reported the highest positive balance of trade, 24.2% of GDP and per capita GDP equal to $63,000. Fit the least squares equation both with and without country X and compare the results. Does the fitted slope change by very much? Find the least squares equation without country X. Complete the equation below. Estimated GDP ($ per cap) = ☐ ☐ Trade Bal (%GDP) (Round to the nearest integer as needed.) Data Table - X Trade Balance (%GDP) GDP ($ per capita) -6.3 16,876 15.7 44,932 -0.9 9,334 -7.9…arrow_forwardReliable 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.arrow_forward
- 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.arrow_forwardJensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). Weekly Usage(hours) AnnualMaintenanceExpense 13 17.0 10 22.0 20 30.0 28 37.0 32 47.0 17 30.5 24 32.5 31 39.0 40 51.5 38 40.0 test statistic is 6.90 Find the p-value. (Round your answer to three decimal places.) p-value = State your conclusion. Reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant. Do not reject H0. We conclude that the relationship between weekly usage (hours) and annual maintenance expense (in hundreds of dollars) is significant. Reject H0. We cannot conclude that the relationship between weekly usage…arrow_forwardThe billing department at a local hospital wants to improve its performance. After surveying its patients, they realized the main complaint was about billing errors. The management went back and reviewed their last year's bills. They took about 100 bills for each week of each month and checked for errors. See Excel file for data. Answer. a. Does the month of the year have an effect on the billing errors? b. What type of control chart would you should use? c. Is the billing process under statistical control? Use Minitab to support your answers.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
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License