Pearson eText for Mathematics with Applications In the Management, Natural, and Social Sciences -- Instant Access (Pearson+)
12th Edition
ISBN: 9780137504381
Author: Margaret Lial, Thomas Hungerford
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 10.3, Problem 45E
To determine
To calculate: Estimate
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which phase in a forensic investigation is likely to be most relevant to Excel?
Data analysis
Data entry
Data preparation
Data collection
FIND THE ANSWERS FOR B-2 and C.
A survey found that Massachusetts residents spent an average of $861.75 on the lottery, more than three times the U.S. average. A researcher at a Boston think tank believes that Massachusetts residents spend less than this amount. He surveys 100 Massachusetts residents and asks them about their annual expenditures on the lottery. (You may find it useful to reference the t table.)
Click here for the Excel Data File
a. Specify the competing hypotheses to test the researcher’s claim.multiple choice 1
H0: μ ≥ 861.75; HA: μ < 861.75
b-1. Calculate the value of the test statistic. (Negative value should be indicated by a minus sign. Round final answer to 3 decimal places.)
-0.863
b-2. Find the p-value.multiple choice 2
p-value < 0.01
0.01 p-value < 0.025
0.025 p-value < 0.05
0.05 p-value < 0.10
p-value 0.10
c. At α = 0.10, what is the conclusion?multiple choice 3
Reject H0; there is insufficient evidence…
Answer using MS Excel.
The following table shows the values in General Government Consumption Expenditure (in US) for the Philippines from 2007 to 2016. General government final consumption expenditure includes all government current expenditures for purchases of goods and services (including compensation of employees.) It also includes most expenditures on national defense and security but excludes government military expenditures that are part of government capital formation. (Source: World Bank national accounts data, and OECD National Accounts data files.)
Year Consumption Expenditure
2007
$13,867,990,000
2008
$15,384,520,000
2009
$16,598,320,000
2010
$19,403,620,000
2011
$21,744,840,000
2012
$27,117,510,000
2013
$29,468,210,000
2014
$30,054,320,000
2015
$31,993,260,000
2016
$33,926,500,000
Use any statistical tool or program to construct a bar graph, a pie chart, and a line graph. Which…
Chapter 10 Solutions
Pearson eText for Mathematics with Applications In the Management, Natural, and Social Sciences -- Instant Access (Pearson+)
Ch. 10.1 - Checkpoint 1 A restaurant trade group commissioned...Ch. 10.1 - Checkpoint 2
Make a histogram and a frequency...Ch. 10.1 - Checkpoint 3
Make a stem-and-leaf plot for the...Ch. 10.1 - Checkpoint 4
List the original data for the...Ch. 10.1 - Checkpoint 5
Characterize the shape of the...Ch. 10.1 - SP 500 Stocks The data for Exercises 1 -4 consist...Ch. 10.1 - SP 500 Stocks The data for Exercises 1 -4 consist...Ch. 10.1 - SP 500 Stocks The data for Exercises 1 -4 consist...Ch. 10.1 - SP 500 Stocks The data for Exercises 1 -4 consist...Ch. 10.1 - The data for Exercises 5-10 consist of random...
Ch. 10.1 - The data for Exercises 5-10 consist of random...Ch. 10.1 - The data for Exercises 5-10 consist of random...Ch. 10.1 - The data for Exercises 5-10 consist of random...Ch. 10.1 - The data for Exercises 5-10 consist of random...Ch. 10.1 - The data for Exercises 5-10 consist of random...Ch. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - Prob. 14ECh. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - Prob. 17ECh. 10.1 - Prob. 18ECh. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - For Exercises 11-20, construct a stem-and-leaf...Ch. 10.1 - Describe the shape of each of the given...Ch. 10.1 - Describe the shape of each of the given...Ch. 10.1 - Describe the shape of each of the given...Ch. 10.1 - Describe the shape of each of the given...Ch. 10.1 - Student Loan Defaults The following histogram...Ch. 10.1 - Stocks The following histogram shows the stock...Ch. 10.1 - Cat Ownership The stem-and-leaf plot below...Ch. 10.1 - Personal Bankruptcies The stem-and-leaf plot below...Ch. 10.1 - 29. Test Scores The grade distribution for scores...Ch. 10.1 - 30. Test Scores The grade distribution for scores...Ch. 10.2 - Checkpoint 1
Find the mean dollar amount of the...Ch. 10.2 - Checkpoint 2
Find for the following frequency...Ch. 10.2 - Checkpoint 3
Find the mean of the following...Ch. 10.2 - Checkpoint 4
Find the mean for the college tuition...Ch. 10.2 - Checkpoint 5
Find the median for the given heights...Ch. 10.2 - Checkpoint 6
Find the mode for each of the given...Ch. 10.2 - Checkpoint 7
Following is a list of the number of...Ch. 10.2 - Prob. 8CPCh. 10.2 - Prob. 1ECh. 10.2 - Prob. 2ECh. 10.2 - Prob. 3ECh. 10.2 - Prob. 4ECh. 10.2 - Prob. 5ECh. 10.2 - Prob. 6ECh. 10.2 - Prob. 7ECh. 10.2 - Prob. 8ECh. 10.2 - Prob. 9ECh. 10.2 - Prob. 10ECh. 10.2 - Prob. 11ECh. 10.2 - Prob. 12ECh. 10.2 - Prob. 13ECh. 10.2 - Prob. 14ECh. 10.2 - Find the mode or modes for each of the given lists...Ch. 10.2 - Find the mode or modes for each of the given lists...Ch. 10.2 - Find the mode or modes for each of the given lists...Ch. 10.2 - Find the mode or modes for each of the given lists...Ch. 10.2 - Find the mode or modes for each of the given lists...Ch. 10.2 - 20. When is the median the most appropriate...Ch. 10.2 - 21. When would the mode be an appropriate measure...Ch. 10.2 - Pet Ownership For Exercises 22 and 23, the...Ch. 10.2 - Pet Ownership For Exercises 22 and 23, the...Ch. 10.2 - 24. To predict the outcome of the next...Ch. 10.2 - Work each problem. (See Example 6.) MLB Payrolls...Ch. 10.2 - Work each problem. (See Example 6.) NFL Team...Ch. 10.2 - Work each problem. (See Example 6.)
27. Business...Ch. 10.2 - Work each problem. (See Example 6.) Sirius XM...Ch. 10.2 - Work each problem. (See Example 6.) Dr Pepper and...Ch. 10.2 - Natural Science The table gives the average...Ch. 10.2 - Natural Science The table gives the average...Ch. 10.2 - For Exercises 32-33 determine the shape of the...Ch. 10.2 - For Exercises 32-33 determine the shape of the...Ch. 10.2 - Prob. 34ECh. 10.2 - Prob. 35ECh. 10.2 - For Exercises 36-38, calculate the weighted...Ch. 10.2 - For Exercises 36-38, calculate the weighted...Ch. 10.2 - For Exercises 36-38, calculate the weighted...Ch. 10.2 - Prob. 39ECh. 10.2 - For Exercises 36-38, calculate the weighted...Ch. 10.3 - Checkpoint 1
Find the range for this sample of the...Ch. 10.3 - Checkpoint 2
Find the deviations from the mean for...Ch. 10.3 - Checkpoint 3
Find the standard deviation for a...Ch. 10.3 - Prob. 4CPCh. 10.3 - Prob. 1ECh. 10.3 - Prob. 2ECh. 10.3 - Prob. 3ECh. 10.3 - Prob. 4ECh. 10.3 - Prob. 5ECh. 10.3 - Prob. 6ECh. 10.3 - Prob. 7ECh. 10.3 - Finance Use the following table for Exercises...Ch. 10.3 - Finance Use the following table for Exercises...Ch. 10.3 - Prob. 10ECh. 10.3 - Education Find the standard deviation for the...Ch. 10.3 - Prob. 12ECh. 10.3 - Prob. 13ECh. 10.3 - Prob. 14ECh. 10.3 - Prob. 15ECh. 10.3 - Prob. 16ECh. 10.3 - Prob. 17ECh. 10.3 - Prob. 18ECh. 10.3 - Prob. 19ECh. 10.3 - Prob. 20ECh. 10.3 - Prob. 21ECh. 10.3 - Prob. 22ECh. 10.3 - Prob. 23ECh. 10.3 - Movie Studios' Revenue For Exercises 23-28, use...Ch. 10.3 - Prob. 25ECh. 10.3 - Prob. 26ECh. 10.3 - Prob. 27ECh. 10.3 - Prob. 28ECh. 10.3 - Prob. 29ECh. 10.3 - Prob. 30ECh. 10.3 - Prob. 34ECh. 10.3 - Prob. 31ECh. 10.3 - Prob. 32ECh. 10.3 - Prob. 33ECh. 10.3 - IBM and Microsoft Revenue The following table...Ch. 10.3 - Prob. 36ECh. 10.3 - Prob. 37ECh. 10.3 - Prob. 38ECh. 10.3 - IBM and Microsoft Revenue The following table...Ch. 10.3 - Prob. 40ECh. 10.3 - Prob. 41ECh. 10.3 - Prob. 42ECh. 10.3 - Prob. 43ECh. 10.3 - Prob. 44ECh. 10.3 - Prob. 45ECh. 10.3 - Prob. 46ECh. 10.3 - Prob. 47ECh. 10.3 - Prob. 48ECh. 10.4 - Prob. 1CPCh. 10.4 - Prob. 2CPCh. 10.4 - Prob. 3CPCh. 10.4 - Prob. 4CPCh. 10.4 - Prob. 5CPCh. 10.4 - Prob. 6CPCh. 10.4 - Prob. 7CPCh. 10.4 - 1. The peak in a normal curve occurs directly...Ch. 10.4 - Prob. 2ECh. 10.4 - Prob. 3ECh. 10.4 - Prob. 4ECh. 10.4 - Prob. 5ECh. 10.4 - Prob. 6ECh. 10.4 - Prob. 7ECh. 10.4 - Prob. 8ECh. 10.4 - Find the percentage of the total area under the...Ch. 10.4 - Prob. 10ECh. 10.4 - Prob. 11ECh. 10.4 - Prob. 12ECh. 10.4 - Prob. 13ECh. 10.4 - Prob. 14ECh. 10.4 - Prob. 15ECh. 10.4 - Prob. 16ECh. 10.4 - Prob. 17ECh. 10.4 - Prob. 18ECh. 10.4 - Prob. 19ECh. 10.4 - 20. Using Chebyshev’s theorem and the normal...Ch. 10.4 - Prob. 21ECh. 10.4 - Prob. 22ECh. 10.4 - Prob. 23ECh. 10.4 - Prob. 24ECh. 10.4 - Prob. 25ECh. 10.4 - Prob. 26ECh. 10.4 - Prob. 27ECh. 10.4 - Prob. 28ECh. 10.4 - Prob. 29ECh. 10.4 - Prob. 30ECh. 10.4 - Prob. 31ECh. 10.4 - Prob. 32ECh. 10.4 - Prob. 33ECh. 10.4 - Prob. 34ECh. 10.4 - Prob. 35ECh. 10.4 - Prob. 36ECh. 10.4 - Prob. 37ECh. 10.4 - Prob. 38ECh. 10.4 - Prob. 39ECh. 10.4 - Prob. 40ECh. 10.4 - Prob. 41ECh. 10.4 - Prob. 42ECh. 10.4 - Prob. 43ECh. 10.4 - Prob. 44ECh. 10.4 - Prob. 45ECh. 10.4 - Prob. 46ECh. 10.4 - Prob. 47ECh. 10.4 - Prob. 48ECh. 10.4 - Prob. 49ECh. 10.4 - Education The mean performance score of a large...Ch. 10.4 - Prob. 51ECh. 10.4 - Prob. 52ECh. 10.4 - Job Satisfaction According to a 2016 study...Ch. 10.4 - Prob. 54ECh. 10.4 - Prob. 55ECh. 10.4 - Prob. 56ECh. 10.4 - Prob. 57ECh. 10.4 - Prob. 58ECh. 10.4 - Student Loan Debt According to a report from the...Ch. 10.4 - Prob. 60ECh. 10.4 - Prob. 61ECh. 10.4 - Prob. 62ECh. 10 - NASDAQ 100 Stocks For Exercises 1-10, the data...Ch. 10 - Prob. 2RECh. 10 - Prob. 3RECh. 10 - Prob. 4RECh. 10 - Prob. 5RECh. 10 - Prob. 6RECh. 10 - NASDAQ 100 Stocks For Exercises 1-10, the data...Ch. 10 - Prob. 8RECh. 10 - Prob. 9RECh. 10 - Prob. 10RECh. 10 - Prob. 11RECh. 10 - Prob. 12RECh. 10 - Prob. 13RECh. 10 - Prob. 14RECh. 10 - Prob. 15RECh. 10 - Prob. 16RECh. 10 - Prob. 17RECh. 10 - Prob. 18RECh. 10 - Prob. 19RECh. 10 - Prob. 20RECh. 10 - Prob. 21RECh. 10 - Prob. 22RECh. 10 - Prob. 23RECh. 10 - Prob. 24RECh. 10 - Find the standard deviation for each of the given...Ch. 10 - Prob. 26RECh. 10 - Prob. 27RECh. 10 - Prob. 28RECh. 10 - Prob. 29RECh. 10 - Prob. 30RECh. 10 - Prob. 31RECh. 10 - Prob. 32RECh. 10 - Prob. 33RECh. 10 - Prob. 34RECh. 10 - Prob. 35RECh. 10 - Prob. 36RECh. 10 - Arm Circumference Data from a recent National...Ch. 10 - Prob. 38RECh. 10 - Prob. 39RECh. 10 - Prob. 40RECh. 10 - Prob. 41RECh. 10 - Prob. 42RECh. 10 - Prob. 43RECh. 10 - Prob. 44RECh. 10 - Prob. 45RECh. 10 - Prob. 46RECh. 10 - Prob. 47RECh. 10 - College or University Education A recent...Ch. 10 - College or University Education A recent...Ch. 10 - Prob. 50RECh. 10 - Prob. 51RECh. 10 - Prob. 52RECh. 10 - Prob. 53RECh. 10 - Prob. 54RECh. 10 - Prob. 1CECh. 10 - Prob. 2CECh. 10 - Prob. 3CECh. 10 - Prob. 4CECh. 10 - Prob. 5CECh. 10 - Prob. 6CECh. 10 - Prob. 7CECh. 10 - Prob. 8CECh. 10 - Prob. 9CECh. 10 - Prob. 10CE
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, subject and related others by exploring similar questions and additional content below.Similar questions
- Does Table 2 represent a linear function? If so, finda linear equation that models the data.arrow_forwardPlease help with (d)arrow_forwardA box office analyst seeks to predict opening weekend box office gross for movies. Toward this goal, the analyst plans to use online trailer views as a predictor. For each of the 66 movies, the number of online trailer views from the release of the trailer through the Saturday before a movie opens and the opening weekend box office gross (in millions of dollars) are collected and stored in the accompanying table. Complete the parts below.arrow_forward
- A survey found that Massachusetts residents spent an average of $861.75 on the lottery, more than three times the U.S. average. A researcher at a Boston think tank believes that Massachusetts residents spend less than this amount. He surveys 100 Massachusetts residents and asks them about their annual expenditures on the lottery. (You may find it useful to reference the t table.) Click here for the Excel Data File (The Lottery data below is from the excel file) a. Specify the competing hypotheses to test the researcher’s claim.multiple choice 1 H0: μ = 861.75; HA: μ ≠ 861.75 H0: μ ≥ 861.75; HA: μ < 861.75 H0: μ ≤ 861.75; HA: μ > 861.75 b-1. Calculate the value of the test statistic. (Negative value should be indicated by a minus sign. Round final answer to 3 decimal places.) Test statistic= Lottery 787 605 919 1140 1090 1191 405 795 1050 644 699 518 469 654 708 405 747 791 880 751 795 803 1103 823 765 744…arrow_forwardAnswers for letter d onlyarrow_forwardUse excel in this question: The Motion Picture Distributors Association of Australia collects yearly data on gross box office takings of the films in Australia. Data is provided here for the years 1990-2004. (Unfortunately more recent data is not readily available.) Is the highest box office takings for a film related to the number of films screened in Australia that year? Year No. of films screened Highest box office ($ million) 1990 252 26.1 1991 240 19.22 1992 229 18.73 1993 259 31.74 1994 252 24.65 1995 253 17.93 1996 281 29.29 1997 285 22.7 1998 273 47.33 1999 255 38.72 2000 250 30.72 2001 245 32.05 2002 258 33.81 2003 268 37.14 2004 318 50.35 1. Produce a scatterplot of the relevant data. Comment on the appropriateness of analysing this data using a linear regression model. 2. Use the statistics from a regression analysis of this data to evaluate the evidence for a useful predictive linear relationship between the two variables at the 5%…arrow_forward
- Charity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below 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. 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. Construct a spreadsheet to answer the following questions. Charity # Charity Total Expenses ($) Administrative Expenses (%) Fundraising Expenses (%) Program Expenses (%) 1 American Red Cross 3355147520 3.8 3.9 92.1 2 World Vision 1200410940 3.8 7.6 88.4 3 Smithsonian Institution 1078888839 23.3 2.6 73.7 4 Food For…arrow_forwardCharity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below 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. 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. Construct a spreadsheet to answer the following questions.arrow_forwardCharity Navigator is America's leading independent charity evaluator. The data in the Excel Online file below 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. 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. Construct a spreadsheet to answer the following questions.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Elementary Geometry for College StudentsGeometryISBN:9781285195698Author:Daniel C. Alexander, Geralyn M. KoeberleinPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Elementary Geometry for College Students
Geometry
ISBN:9781285195698
Author:Daniel C. Alexander, Geralyn M. Koeberlein
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
The Shape of Data: Distributions: Crash Course Statistics #7; Author: CrashCourse;https://www.youtube.com/watch?v=bPFNxD3Yg6U;License: Standard YouTube License, CC-BY
Shape, Center, and Spread - Module 20.2 (Part 1); Author: Mrmathblog;https://www.youtube.com/watch?v=COaid7O_Gag;License: Standard YouTube License, CC-BY
Shape, Center and Spread; Author: Emily Murdock;https://www.youtube.com/watch?v=_YyW0DSCzpM;License: Standard Youtube License