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
Many global retailers target China, India and emerging markets. What are some of the ethical implications that might arise for global retailers? Select one of the ethical issues to comment on.
Hello tutor solve this question and accounting
Can you solve this general accounting question with accurate accounting calculations?
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
- Please provide the solution to this general accounting question with accurate financial calculations.arrow_forwardMarketing to the Bottom of the Pyramid (BOP) Review the Marketing to the Bottom of the Pyramid case study. This case can be found in the “Case” section of your required textbook. As a junior member of your company’s committee to explore new markets, you have received a memo from the chairperson telling you to be prepared at the next meeting to discuss key questions that need to be addressed if the company decides to look further into marketing to the BOP segment. Compile a PowerPoint presentation that you will deliver at the next meeting to underpin a set of general guidelines to use in developing a strategy for any one of the company’s products to be marketed to the “aspirational poor.” These guidelines do not need to be company or product specific, and can almost resemble a checklist of questions that the company could use as a starting point in evaluating the potential of a specific BOP marketing segment for one of its products. Be sure to incorporate concepts from the case study,…arrow_forwardI need help with this general accounting problem using proper accounting guidelines.arrow_forward
- Starbucks Corporation wants to make a profit of $32,000. It has variable costs of $65 per unit and fixed costs of $18,000. How much must it charge per unit if 5,000 units are sold?arrow_forwardSolution accountingarrow_forwardI am searching for the most suitable approach to this financial accounting problem with valid standards.arrow_forward
- incorrect solution will get unhelpful ratearrow_forwardYou are given the following information about Zephyr Company in 2021: The Company’s fixed costs are expected to be $195,000, the selling price per unit is $17, and the variable cost per unit is $5. The company wants to earn a net income of $84,000 during 2021. The required sales units to meet the target net income during 2021 is _.arrow_forwardI want the correct answer with accounting questionarrow_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