EBK BUSINESS ANALYTICS
3rd Edition
ISBN: 9780136880844
Author: Evans
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 8, Problem 2PE
To determine
To construct: A scatter chart and find the type of model that is best for the provided data. Also, find the model equation using the Trendline tool.
Expert Solution & Answer
Answer to Problem 2PE
The best model for the given data is linear model.
Explanation of Solution
Given information:
The data set is:
| Price | Demand |
| $11 | 2180 |
| $13 | 2020 |
| $17 | 1980 |
| $19 | 1900 |
Graph:
The
- Enter data in excel sheet.
- Select the data of Price and Demand.
- Click on Insert > Charts > Scatter.
The obtained scatterplot is:
Interpretation:
From the above constructed scatterplot, it is clear that the data points of provided data set are forming straight line downward patter which implies that the linear model is appropriate for the given data set.
Hence, linear model is best representing the given data set.
Calculation:
Follow the provided steps of excel to find the trendline equation:
- Select the chart.
- Click on + symbol and select Trendline and click on more options.
- Select the Regression Type as linear.
- Tick on Display equation on chart.
The obtained results is
Hence, the required trendline is y=-30x+2470.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Suppose that you want to estimate the mean monthly gross income of all households in your local community. You decide to estimate this population parameter by calling 150 randomly selected residents and asking each individual to report the household’s monthly income. Assume that you use the local phone directory as the frame in selecting the households to be included in your sample.
What are some possible sources of error that might arise in your effort to estimate the population mean?
For the distribution shown, match the letter to the measure of central tendency.
A B C
C
Drag each of the letters into the appropriate measure of central tendency.
Mean
C
Median
A
Mode
B
A physician who has a group of 38 female patients aged 18 to 24 on a special diet wishes to estimate the effect of the diet on total serum cholesterol. For this group, their average serum cholesterol is 188.4 (measured in mg/100mL). Suppose that the total serum cholesterol measurements are normally distributed with standard deviation of 40.7. (a) Find a 95% confidence interval of the mean serum cholesterol of patients on the special diet.
Chapter 8 Solutions
EBK BUSINESS ANALYTICS
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
- The accompanying data represent the weights (in grams) of a simple random sample of 10 M&M plain candies. Determine the shape of the distribution of weights of M&Ms by drawing a frequency histogram. Find the mean and median. Which measure of central tendency better describes the weight of a plain M&M? Click the icon to view the candy weight data. Draw a frequency histogram. Choose the correct graph below. ○ A. ○ C. Frequency Weight of Plain M and Ms 0.78 0.84 Frequency OONAG 0.78 B. 0.9 0.96 Weight (grams) Weight of Plain M and Ms 0.84 0.9 0.96 Weight (grams) ○ D. Candy Weights 0.85 0.79 0.85 0.89 0.94 0.86 0.91 0.86 0.87 0.87 - Frequency ☑ Frequency 67200 0.78 → Weight of Plain M and Ms 0.9 0.96 0.84 Weight (grams) Weight of Plain M and Ms 0.78 0.84 Weight (grams) 0.9 0.96 →arrow_forwardThe acidity or alkalinity of a solution is measured using pH. A pH less than 7 is acidic; a pH greater than 7 is alkaline. The accompanying data represent the pH in samples of bottled water and tap water. Complete parts (a) and (b). Click the icon to view the data table. (a) Determine the mean, median, and mode pH for each type of water. Comment on the differences between the two water types. Select the correct choice below and fill in any answer boxes in your choice. A. For tap water, the mean pH is (Round to three decimal places as needed.) B. The mean does not exist. Data table Тар 7.64 7.45 7.45 7.10 7.46 7.50 7.68 7.69 7.56 7.46 7.52 7.46 5.15 5.09 5.31 5.20 4.78 5.23 Bottled 5.52 5.31 5.13 5.31 5.21 5.24 - ☑arrow_forwardく Chapter 5-Section 1 Homework X MindTap - Cengage Learning x + C webassign.net/web/Student/Assignment-Responses/submit?pos=3&dep=36701632&tags=autosave #question3874894_3 M Gmail 品 YouTube Maps 5. [-/20 Points] DETAILS MY NOTES BBUNDERSTAT12 5.1.020. ☆ B Verify it's you Finish update: All Bookmarks PRACTICE ANOTHER A computer repair shop has two work centers. The first center examines the computer to see what is wrong, and the second center repairs the computer. Let x₁ and x2 be random variables representing the lengths of time in minutes to examine a computer (✗₁) and to repair a computer (x2). Assume x and x, are independent random variables. Long-term history has shown the following times. 01 Examine computer, x₁₁ = 29.6 minutes; σ₁ = 8.1 minutes Repair computer, X2: μ₂ = 92.5 minutes; σ2 = 14.5 minutes (a) Let W = x₁ + x2 be a random variable representing the total time to examine and repair the computer. Compute the mean, variance, and standard deviation of W. (Round your answers…arrow_forward
- The acidity or alkalinity of a solution is measured using pH. A pH less than 7 is acidic; a pH greater than 7 is alkaline. The accompanying data represent the pH in samples of bottled water and tap water. Complete parts (a) and (b). Click the icon to view the data table. (a) Determine the mean, median, and mode pH for each type of water. Comment on the differences between the two water types. Select the correct choice below and fill in any answer boxes in your choice. A. For tap water, the mean pH is (Round to three decimal places as needed.) B. The mean does not exist. Data table Тар Bottled 7.64 7.45 7.46 7.50 7.68 7.45 7.10 7.56 7.46 7.52 5.15 5.09 5.31 5.20 4.78 5.52 5.31 5.13 5.31 5.21 7.69 7.46 5.23 5.24 Print Done - ☑arrow_forwardThe median for the given set of six ordered data values is 29.5. 9 12 23 41 49 What is the missing value? The missing value is ☐.arrow_forwardFind the population mean or sample mean as indicated. Sample: 22, 18, 9, 6, 15 □ Select the correct choice below and fill in the answer box to complete your choice. O A. x= B. μεarrow_forward
- Why the correct answer is letter A? Students in an online course are each randomly assigned to receive either standard practice exercises or adaptivepractice exercises. For the adaptive practice exercises, the next question asked is determined by whether the studentgot the previous question correct. The teacher of the course wants to determine whether there is a differencebetween the two practice exercise types by comparing the proportion of students who pass the course from eachgroup. The teacher plans to test the null hypothesis that versus the alternative hypothesis , whererepresents the proportion of students who would pass the course using standard practice exercises andrepresents the proportion of students who would pass the course using adaptive practice exercises.The teacher knows that the percent confidence interval for the difference in proportion of students passing thecourse for the two practice exercise types (standard minus adaptive) is and the percent…arrow_forwardCarpetland salespersons average $8,000 per week in sales. Steve Contois, the firm's vice president, proposes a compensation plan with new selling incentives. Steve hopes that the results of a trial selling period will enable him to conclude that the compensation plan increases the average sales per salesperson. a. Develop the appropriate null and alternative hypotheses.H 0: H a:arrow_forwardتوليد تمرين شامل حول الانحدار الخطي المتعدد بطريقة المربعات الصغرىarrow_forward
- The U.S. Postal Service will ship a Priority Mail® Large Flat Rate Box (12" 3 12" 3 5½") any where in the United States for a fixed price, regardless of weight. The weights (ounces) of 20 ran domly chosen boxes are shown below. (a) Make a stem-and-leaf diagram. (b) Make a histogram. (c) Describe the shape of the distribution. Weights 72 86 28 67 64 65 45 86 31 32 39 92 90 91 84 62 80 74 63 86arrow_forward(a) What is a bimodal histogram? (b) Explain the difference between left-skewed, symmetric, and right-skewed histograms. (c) What is an outlierarrow_forward(a) Test the hypothesis. Consider the hypothesis test Ho = : against H₁o < 02. Suppose that the sample sizes aren₁ = 7 and n₂ = 13 and that $² = 22.4 and $22 = 28.2. Use α = 0.05. Ho is not ✓ rejected. 9-9 IV (b) Find a 95% confidence interval on of 102. Round your answer to two decimal places (e.g. 98.76).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
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Elementary AlgebraAlgebraISBN:9780998625713Author:Lynn Marecek, MaryAnne Anthony-SmithPublisher:OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
What is a Relation? | Don't Memorise; Author: Don't Memorise;https://www.youtube.com/watch?v=hV1_wvsdJCE;License: Standard YouTube License, CC-BY
RELATIONS-DOMAIN, RANGE AND CO-DOMAIN (RELATIONS AND FUNCTIONS CBSE/ ISC MATHS); Author: Neha Agrawal Mathematically Inclined;https://www.youtube.com/watch?v=u4IQh46VoU4;License: Standard YouTube License, CC-BY