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
Using High low method, what is variable cost per unit?
Don't use ai given answer accounting questions
Ans
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
- Nonearrow_forward1. Which of the following assets is most likely to trade over the counter but still have high liquidity? a. A short-term Treasury bond b. A long-term corporate bond c. A short-term corporate bond d. A large-cap stock e. A small-cap stock 2. Assume you purchased 600 shares of XYZ common stock on margin at $35 per share from your broker. If the initial margin is 60%, the amount you borrowed from the broker is closest to _________. a. $8,500 b. $21,000 c. $29,500 d. $12,500 e. $16,000 3. You invest $1,550 in security A with a beta of 1.4 and $1,350 in security B with a beta of 0.4. The beta of this portfolio is closest to _____________ . a. 0.95 b. 0.90 c. 1.35 d. 1.05 e. 1.15 4. Which of the following orders is most likely to increase the difference between the highest bid price and the lowest ask price? a. A large market order b. A large limit order c. A small limit order d. A small market order e. There will be no major difference between these 5. Bond X is worth $91 today.…arrow_forwardGeneral Accounting Questionarrow_forward
- Parker Industries applies manufacturing overhead costs to products at a budgeted indirect-cost rate of $60 per direct manufacturing labor hour. A client has requested a bid on a special order for a customized bracelet. Estimates for this order include: Direct materials of $52,000, 450 direct manufacturing labor hours at $18 per hour, and a 40% markup rate on total manufacturing costs. What is the bid price for this special order?arrow_forwardHow many dollars worth of sales are generated from every $1 in total assets?arrow_forwardCan you help me with accounting questionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing
Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
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