Approximately 86.5% of Americans commute to work by car, truck, or van. Out of that group, 84.6% drive alone and 15.4% drive In a carpool. Approximately 3.9% walk to work and approximately 5.3% take public transportation. a. Construct a table or a tree diagram of the situation. Include a branch for all other modes of transportation to work. b. Assuming that the walkers walk alone, what percent of all commuters navel alone to work? c. Suppose that 1,000 workers are randomly selected. How many would you expect to travel alone to work? d. Suppose that 1.000 workers are randomly selected. How many would you expect to drive In a carpool?
Approximately 86.5% of Americans commute to work by car, truck, or van. Out of that group, 84.6% drive alone and 15.4% drive In a carpool. Approximately 3.9% walk to work and approximately 5.3% take public transportation. a. Construct a table or a tree diagram of the situation. Include a branch for all other modes of transportation to work. b. Assuming that the walkers walk alone, what percent of all commuters navel alone to work? c. Suppose that 1,000 workers are randomly selected. How many would you expect to travel alone to work? d. Suppose that 1.000 workers are randomly selected. How many would you expect to drive In a carpool?
Approximately 86.5% of Americans commute to work by car, truck, or van. Out of that group, 84.6% drive alone and 15.4% drive In a carpool. Approximately 3.9% walk to work and approximately 5.3% take public transportation.
a. Construct a table or a tree diagram of the situation. Include a branch for all other modes of transportation to work.
b. Assuming that the walkers walk alone, what percent of all commuters navel alone to work?
c. Suppose that 1,000 workers are randomly selected. How many would you expect to travel alone to work?
d. Suppose that 1.000 workers are randomly selected. How many would you expect to drive In a carpool?
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,…
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 deviation
University Calculus: Early Transcendentals (4th Edition)
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.
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