Elementary Statistics Using Excel (6th Edition)
6th Edition
ISBN: 9780134506623
Author: Mario F. Triola
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 8, Problem 2CRE
To determine
Mentionthe null hypothesis, alternative hypothesis, test statistic, P-value and state the conclusion.
Test whether there is a sufficient evidence to support the claim that the ballot selection method favours democrats.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Three cat-
ency bar 10 Suppose that a health club asks 30 customers
ad to rate the services as very good (1), good (2),
fair (3), or poor (4). You can see the results
in the following bar graph. What percentage
of the customers rated the services as good?
n; 2:
pinion).
of this
to make a
eople in
ng ban?)
Health Club Customer Ratings (1-very good,..., 4-poor)
Frequency
10
8
00
6
11
A polling orga
what voters t
random samp
for their opin
no opinion.
following ba
a. Make a
(includ
bob. Evalua
fairly
tral
2
0
1
-2
3
4
540
480
420
360
300
240
Frequency
1 - Multiple Regression Equations and Predictions with XLMiner Analysis ToolPak (Structured)
Video
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a
sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the
designated areas of the spreadsheet.
Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPak
X
Open spreadsheet
a. Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals).
JAN
27
Revenue =
× TVAdv
+
b. Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals).
Revenue =
+
TVAdy +
NewsAdv
c. Is the estimated regression equation coefficient for…
Question 2: When John started his first job, his first end-of-year salary was $82,500. In the following years, he received salary raises as shown in the following table.
Fill the Table: Fill the following table showing his end-of-year salary for each year. I have already provided the end-of-year salaries for the first three years. Calculate the end-of-year salaries for the remaining years using Excel. (If you Excel answer for the top 3 cells is not the same as the one in the following table, your formula / approach is incorrect) (2 points)
Geometric Mean of Salary Raises: Calculate the geometric mean of the salary raises using the percentage figures provided in the second column named “% Raise”. (The geometric mean for this calculation should be nearly identical to the arithmetic mean. If your answer deviates significantly from the mean, it's likely incorrect. 2 points)
Hint for the first part of question 2: To assist you with filling out the table in the first part of the question,…
Chapter 8 Solutions
Elementary Statistics Using Excel (6th Edition)
Ch. 8.1 - 1. Vitamin C and Aspirin A bottle contains a label...Ch. 8.1 - 2. Estimates and Hypothesis Tests Data Set 3 “Body...Ch. 8.1 - 3. Mean Height of Men A formal hypothesis test is...Ch. 8.1 - 4. Interpreting P-value The Ericsson method is one...Ch. 8.1 - Identifying H0 and H1. In Exercises 5–8, do the...Ch. 8.1 - Identifying H0 and H1. In Exercises 5–8, do the...Ch. 8.1 - Prob. 7BSCCh. 8.1 - Identifying H0 and H1. In Exercises 5–8, do the...Ch. 8.1 - Prob. 9BSCCh. 8.1 - Conclusions. In Exercises 9 – 12, refer to the...
Ch. 8.1 - Prob. 11BSCCh. 8.1 - Conclusions. In Exercises 9 – 12, refer to the...Ch. 8.1 - Prob. 13BSCCh. 8.1 - Prob. 14BSCCh. 8.1 - Prob. 15BSCCh. 8.1 - Prob. 16BSCCh. 8.1 - Prob. 17BSCCh. 8.1 - P -Values. In Exercises 17 ‒ 20, do the...Ch. 8.1 - P -Values. In Exercises 17 ‒ 20, do the...Ch. 8.1 - Prob. 20BSCCh. 8.1 - Prob. 21BSCCh. 8.1 - Prob. 22BSCCh. 8.1 - Prob. 23BSCCh. 8.1 - Prob. 24BSCCh. 8.1 - Prob. 25BSCCh. 8.1 - Prob. 26BSCCh. 8.1 - Prob. 27BSCCh. 8.1 - Final Conclusions. In Exercises 25–28, use a...Ch. 8.1 - Prob. 29BSCCh. 8.1 - Prob. 30BSCCh. 8.1 - Prob. 31BSCCh. 8.1 - Prob. 32BSCCh. 8.1 - Prob. 33BBCh. 8.1 - Prob. 34BBCh. 8.1 - Prob. 35BBCh. 8.2 - In Exercises 1–4, use these results from a USA...Ch. 8.2 - Prob. 2BSCCh. 8.2 - Prob. 3BSCCh. 8.2 - Prob. 4BSCCh. 8.2 - Prob. 5BSCCh. 8.2 - Prob. 6BSCCh. 8.2 - Prob. 7BSCCh. 8.2 - Prob. 8BSCCh. 8.2 - Prob. 9BSCCh. 8.2 - Prob. 10BSCCh. 8.2 - Prob. 11BSCCh. 8.2 - Prob. 12BSCCh. 8.2 - Testing Claims About Proportions. In Exercises 9 –...Ch. 8.2 - Prob. 14BSCCh. 8.2 - Prob. 15BSCCh. 8.2 - Prob. 16BSCCh. 8.2 - Prob. 17BSCCh. 8.2 - Prob. 18BSCCh. 8.2 - Prob. 19BSCCh. 8.2 - Prob. 20BSCCh. 8.2 - Prob. 21BSCCh. 8.2 - Prob. 22BSCCh. 8.2 - Prob. 23BSCCh. 8.2 - Prob. 24BSCCh. 8.2 - Prob. 25BSCCh. 8.2 - Prob. 26BSCCh. 8.2 - Prob. 27BSCCh. 8.2 - Prob. 28BSCCh. 8.2 - Prob. 29BSCCh. 8.2 - Prob. 30BSCCh. 8.2 - Prob. 31BSCCh. 8.2 - Prob. 32BSCCh. 8.2 - Prob. 33BBCh. 8.2 - Prob. 34BBCh. 8.2 - Prob. 35BBCh. 8.3 - Video Games: Checking Requirements Twelve...Ch. 8.3 - Prob. 2BSCCh. 8.3 - Prob. 3BSCCh. 8.3 - Prob. 4BSCCh. 8.3 - Prob. 5BSCCh. 8.3 - Prob. 6BSCCh. 8.3 - Prob. 7BSCCh. 8.3 - Prob. 8BSCCh. 8.3 - Prob. 9BSCCh. 8.3 - Prob. 10BSCCh. 8.3 - Prob. 11BSCCh. 8.3 - Prob. 12BSCCh. 8.3 - Prob. 13BSCCh. 8.3 - Testing Hypotheses. In Exercises 13–24, assume...Ch. 8.3 - Prob. 15BSCCh. 8.3 - Prob. 16BSCCh. 8.3 - Prob. 17BSCCh. 8.3 - Testing Hypotheses. In Exercises 13–24, assume...Ch. 8.3 - Prob. 19BSCCh. 8.3 - Prob. 20BSCCh. 8.3 - Prob. 21BSCCh. 8.3 - Prob. 22BSCCh. 8.3 - Prob. 23BSCCh. 8.3 - Testing Hypotheses. In Exercises 13–24, assume...Ch. 8.3 - Prob. 25BSCCh. 8.3 - Prob. 26BSCCh. 8.3 - Prob. 27BSCCh. 8.3 - Prob. 28BSCCh. 8.3 - Prob. 31BBCh. 8.3 - 32. Interpreting Power For the sample data in...Ch. 8.4 - Prob. 1BSCCh. 8.4 - Cans of Coke Use the data and the claim given in...Ch. 8.4 - Prob. 3BSCCh. 8.4 - Prob. 4BSCCh. 8.4 - Prob. 5BSCCh. 8.4 - Prob. 6BSCCh. 8.4 - Prob. 7BSCCh. 8.4 - Prob. 8BSCCh. 8.4 - Prob. 9BSCCh. 8.4 - Prob. 10BSCCh. 8.4 - Prob. 11BSCCh. 8.4 - Prob. 12BSCCh. 8.4 - Prob. 13BSCCh. 8.4 - Prob. 14BSCCh. 8.4 - Prob. 15BSCCh. 8.4 - Prob. 16BSCCh. 8.4 - Prob. 17BSCCh. 8.4 - Prob. 18BSCCh. 8.4 - Prob. 19BBCh. 8.4 - Prob. 20BBCh. 8 - Prob. 1CQQCh. 8 - Prob. 2CQQCh. 8 - Prob. 3CQQCh. 8 - Prob. 4CQQCh. 8 - Prob. 5CQQCh. 8 - Prob. 6CQQCh. 8 - Prob. 7CQQCh. 8 - Prob. 8CQQCh. 8 - Prob. 9CQQCh. 8 - Prob. 10CQQCh. 8 - Prob. 1CRECh. 8 - Prob. 2CRECh. 8 - Prob. 3CRECh. 8 - Red Blood Cell Count A simple random sample of 40...Ch. 8 - Prob. 5CRECh. 8 - Prob. 6CRECh. 8 - BMI for Miss America Use the same BMI indexes...Ch. 8 - Lightning Deaths Based on the results given in...Ch. 8 - Prob. 1.1CRECh. 8 - Prob. 1.2CRECh. 8 - Prob. 1.3CRECh. 8 - Prob. 1.4CRECh. 8 - Prob. 1.5CRECh. 8 - Prob. 1.6CRECh. 8 - Prob. 1.7CRECh. 8 - Prob. 1.8CRECh. 8 - Prob. 1EPCh. 8 - Prob. 1FDD
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
- Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28, and 25. Compute the range, interquartile range, variance, and standard deviation (to a maximum of 2 decimals, if decimals are necessary). Range Interquartile range Variance Standard deviationarrow_forwardPerform a Step by step following tests in Microsoft Excel. Each of the following is 0.5 points, with a total of 6 points. Provide your answers in the following table. Median Standard Deviation Minimum Maximum Range 1st Quartile 2nd Quartile 3rd Quartile Skewness; provide a one sentence explanation of what does the skewness value indicates Kurtosis; provide a one sentence explanation of what does the kurtosis value indicates Make a labelled histogram; no point awarded if it is not labelled Make a labelled boxplot; no point awarded if it is not labelled Data 27 30 22 25 24 22 20 28 20 26 21 23 24 20 28 30 20 28 29 30 21 26 29 25 26 25 20 30 26 28 25 21 22 27 27 24 26 22 29 28 30 22 22 22 30 21 21 30 26 20arrow_forwardObtain the linear equation for trend for time series with St² = 140, Ey = 16.91 and Σty= 62.02, m n = 7arrow_forward
- A quality characteristic of a product is normally distributed with mean μ and standard deviation σ = 1. Speci- fications on the characteristic are 6≤x≤8. A unit that falls within specifications on this quality characteristic results in a profit of Co. However, if x 8, the profit is -C2. Find the value ofμ that maximizes the expected profit.arrow_forwardA) The output voltage of a power supply is normally distributed with mean 5 V and standard deviation 0.02 V. If the lower and upper specifications for voltage are 4.95 V and 5.05 V, respectively, what is the probability that a power supply selected at random conform to the specifications on voltage? B) Continuation of A. Reconsider the power supply manufacturing process in A. Suppose We wanted to improve the process. Can shifting the mean reduce the number of nonconforming units produced? How much would the process variability need to be reduced in order to have all but one out of 1000 units conform to the specifications?arrow_forwardder to complete the Case X T Civil Service Numerical Test Sec X T Casework Skills Practice Test Maseline Vaseline x + euauthoring.panpowered.com/DeliveryWeb/Civil Service Main/84589a48-6934-4b6e-a6e1-a5d75f559df9?transferToken-News NGSSON The table below shows the best price available for various items from 4 uniform suppliers. The prices do not include VAT (charged at 20%). Item Waterproof boots A1-Uniforms (£)Best Trade (£)Clothing Tech (£)Dress Right (£) 59.99 39.99 59.99 49.99 Trousers 9.89 9.98 9.99 11.99 Shirts 14.99 15.99 16.99 12.99 Hi-Vis vest 4.49 4.50 4.00 4.00 20.00 25.00 19.50 19.99 Hard hats A company needs to buy a set of 12 uniforms which includes 1 of each item. If the special offers are included which supplier is cheapest? OOO A1-Uniforms Best Trade Clothing Tech Q Search + ** 109 8 CO* F10 Home F11 F12 6arrow_forward
- to complete the Case × T Civil Service Numerical Test Sec x T Casework Skills Practice Test + Vaseline euauthoring.panpowered.com/DeliveryWeb/Civil Service Main/84589a48-b934-4b6e-a6e1-a5d75f559df9?transferToken=MxNewOS NGFSPSZSMOMzuz The table below shows the best price available for various items from 4 uniform suppliers. The prices do not include VAT (charged at 20%). Item A1-Uniforms (£)Best Trade (£)Clothing Tech (£)Dress Right (£) Waterproof boots 59.99 39.99 59.99 49.99 Trousers 9.89 9.98 9.99 11.99 Shirts 14.99 15.99 16.99 12.99 Hi-Vis vest 4.49 4.50 4.00 4.00 20.00 25.00 19.50 19.99 Hard hats A company needs to buy a set of 12 uniforms which includes 1 of each item. If the special offers are included, which supplier is cheapest? O O O O A1-Uniforms Best Trade Clothing Tech Dress Right Q Search ENG L UK +0 F6 四吧 6 78 ㄓ F10 9% * CO 1 F12 34 Oarrow_forwardCritics review films out of 5 based on three attributes: the story, the special effects and the acting. The ratings of four critics for a film are collected in the table below.CriticSpecialStory rating Effects rating Acting rating Critic 14.44.34.5Critic 24.14.23.9Critic 33.943.4Critic 44.24.14.2Critic 1 also gave the film a rating for the Director's ability. If the average of Critic 1's ratings was 4.3 what rating did they give to the Director's ability?3.94.04.14.24.3arrow_forwardTwo measurements are made of some quantity. For the first measurement, the average is 74.4528, the RMS error is 6.7441, and the uncertainty of the mean is 0.9264. For the second one, the average is 76.8415, the standard deviation is 8.3348, and the uncertainty of the mean is 1.1448. The expected value is exactly 75. 13. Express the first measurement in public notation. 14. Is there a significant difference between the two measurements? 1 15. How does the first measurement compare with the expected value? 16. How does the second measurement compare with the expected value?arrow_forward
- A hat contains slips of paper numbered 1 through 6. You draw two slips of paper at random from the hat,without replacing the first slip into the hat.(a) (5 points) Write out the sample space S for this experiment.(b) (5 points) Express the event E : {the sum of the numbers on the slips of paper is 4} as a subset of S.(c) (5 points) Find P(E)(d) (5 points) Let F = {the larger minus the smaller number is 0}. What is P(F )?(e) (5 points) Are E and F disjoint? Why or why not?(f) (5 points) Find P(E ∪ F )arrow_forwardIn addition to the in-school milk supplement program, the nurse would like to increase the use of daily vitamin supplements for the children by visiting homes and educating about the merits of vitamins. She believes that currently, about 50% of families with school-age children give the children a daily megavitamin. She would like to increase this to 70%. She plans a two-group study, where one group serves as a control and the other group receives her visits. How many families should she expect to visit to have 80% power of detecting this difference? Assume that drop-out rate is 5%.arrow_forwardA recent survey of 400 americans asked whether or not parents do too much for their young adult children. The results of the survey are shown in the data file. a) Construct the frequency and relative frequency distributions. How many respondents felt that parents do too much for their adult children? What proportion of respondents felt that parents do too little for their adult children? b) Construct a pie chart. Summarize the findingsarrow_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
Probability & Statistics (28 of 62) Basic Definitions and Symbols Summarized; Author: Michel van Biezen;https://www.youtube.com/watch?v=21V9WBJLAL8;License: Standard YouTube License, CC-BY
Introduction to Probability, Basic Overview - Sample Space, & Tree Diagrams; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=SkidyDQuupA;License: Standard YouTube License, CC-BY