1. Find a linear regression line for Facebook's net income using the scatter graph method. (where 2012 = time zero) a. Ensure your graph displays the linear equation b. Ensure your graph displays the R-Squared C. Ensure your graph is well labelled and titled d. Do you think a linear function is appropriate? Why or why not? %3D 2. Repeat step 1 above using a quadratic function 3. Repeat step 1 above using an exponential function

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Styles
Learning Outcomes:
1. Become comfortable working with data in Excel
2. Distinguish among linear functions, quadratic functions, and exponential
functions
3. Generate a well-organized spreadsheet report
The data below shows the annual net income (profit) of Facebook (in $ millions) since
2012
Year
2012
2013
2014
2015
2016
2017
2018
Net Income
53
1,500
2,940
3,688
15,920
Source: sec.gov
10,188
22,112
REQUIRED: Using Excel
1. Find a linear regression line for Facebook's net income using the scatter graph
method. (where 2012 = time zero)
a. Ensure your graph displays the linear equation
b. Ensure your graph displays the R-Squared
C. Ensure your graph is well labelled and titled
d. Do you think a linear function is appropriate? Why or why not?
2. Repeat step 1 above using a quadratic function
3. Repeat step 1 above using an exponential function
4. Comment on the function that best models Facebook's net income as a function
of time
a. Using the best model, come up with a table showing the projected annual
profits for Facebook for years 2019 to 2030
Transcribed Image Text:Styles Learning Outcomes: 1. Become comfortable working with data in Excel 2. Distinguish among linear functions, quadratic functions, and exponential functions 3. Generate a well-organized spreadsheet report The data below shows the annual net income (profit) of Facebook (in $ millions) since 2012 Year 2012 2013 2014 2015 2016 2017 2018 Net Income 53 1,500 2,940 3,688 15,920 Source: sec.gov 10,188 22,112 REQUIRED: Using Excel 1. Find a linear regression line for Facebook's net income using the scatter graph method. (where 2012 = time zero) a. Ensure your graph displays the linear equation b. Ensure your graph displays the R-Squared C. Ensure your graph is well labelled and titled d. Do you think a linear function is appropriate? Why or why not? 2. Repeat step 1 above using a quadratic function 3. Repeat step 1 above using an exponential function 4. Comment on the function that best models Facebook's net income as a function of time a. Using the best model, come up with a table showing the projected annual profits for Facebook for years 2019 to 2030
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Differential Equation
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
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman