Question: Your goal for this lab is to create a scatter diagram of the data, then do a linear, exponential, and logarithmic regression. Provide the equations

Your goal for this lab is to create a scatter diagram

Your goal for this lab is to create a scatter diagram of the data, then do a linear, exponential, and logarithmic regression. Provide the equations and the value of R^2 in your graphs. Do the regression on each book which you can see below. Then, predict the average stock price of APPLE INC. for the the year 2022. Of the three regressions that you did, which do you think will be the closest prediction for 2022?

PLEASE SHOW LINEAR, EXPONENTIAL AND LOGARITHMIC REGRESSION IN EXCEL. thank you :)

Below is the average stock price of APPLE INC. for the past 20 years. https://www.macrotrends.net/stocks/ charts/AAPL/apple/stock-price-history Your goal for this lab is to create a scatter diagram of the data, then do a linear, exponential and logarithmic regression. Provide the equations and the value of R^2 in your graphs. Do the regression on each book which you can see below. Then, predict the average stock price of APPLE INC. for the the year 2022. Of the three regressions that you did, which do you think will be the closest prediction for 2022? x: the number of years from 1990 y: the average stock price *Use these definitions of x and y before you do your regression! Average PREDICTED STOCK PRICES FOR 2022. Linear Regression: Exponential Regression: Logarithmic Regression: Actual Value based on your research YEAR 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Stock Price $ 0.47 0.49 $ 0.37 $ 0.30 $ 0.36 $ 0.22 $ 0.16 $ 0.27 $ 0.52 $ 0.82 $ 0.36 0.34 $ 0.33 $ 0.63 $ 1.67 $ 2.53 $ 4.58 $ 5.07 $ 5.24 $ 9.28 $ 13.00 $ 20.57 $ 16.88 $ 23.07 $ 30.01 $ 26.15 $ 37.64 $ 47.26 $ 52.06 $ 95.35 $140.99 PLEASE TYPE YOUR CONCLUSION IN THIS BOX. Below is the average stock price of APPLE INC. for the past 20 years. https://www.macrotrends.net/stocks/ charts/AAPL/apple/stock-price-history Your goal for this lab is to create a scatter diagram of the data, then do a linear, exponential and logarithmic regression. Provide the equations and the value of R^2 in your graphs. Do the regression on each book which you can see below. Then, predict the average stock price of APPLE INC. for the the year 2022. Of the three regressions that you did, which do you think will be the closest prediction for 2022? x: the number of years from 1990 y: the average stock price *Use these definitions of x and y before you do your regression! Average PREDICTED STOCK PRICES FOR 2022. Linear Regression: Exponential Regression: Logarithmic Regression: Actual Value based on your research YEAR 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Stock Price $ 0.47 0.49 $ 0.37 $ 0.30 $ 0.36 $ 0.22 $ 0.16 $ 0.27 $ 0.52 $ 0.82 $ 0.36 0.34 $ 0.33 $ 0.63 $ 1.67 $ 2.53 $ 4.58 $ 5.07 $ 5.24 $ 9.28 $ 13.00 $ 20.57 $ 16.88 $ 23.07 $ 30.01 $ 26.15 $ 37.64 $ 47.26 $ 52.06 $ 95.35 $140.99 PLEASE TYPE YOUR CONCLUSION IN THIS BOX

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

1: How should Fosdick respond to the immediate situation? 2: What controls, of the types discussed in this chapter, might have been used by Red Spot Markets to reduce or eliminate the problems...

Problem 3 [from Case 9.3 of the textbookl 50 points total Nolan Banks is an auditor for the Public Service Commission for the state of Georgia. The Public Service Commission is a government agency...

Please do problems #24, 25, 26, 29, 32, 34, 37, 40, 42, 50, 51, 54, 55, 59 Math 155 Lab (4.4-4.7).pdf Q CHAPTER 4 REVIEW 435 21. Evaluate In(e-0.8648) without using a calculator. 22. Evaluate In(V18...

Now go to COVID Data Tracker Use the tool to find the total number of deaths for each of the states you selected in #1. Use the most recent date that is available to complete the third column in the...

deacribe the main findings of this paper 400 words (be clear on what the analysis involved says, interpret results, or if you could redo the study, what other varaibles or questions would you...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

Just some points on the main findings of the paper/ what the results mean! 6 67% + T Applying Regression Models to Predict Business Results Jelena Rusov PhD Student Durereado, grade Mirjana Misita...

One important measure of workers' performance is their attendance record. A personnel manager at a large company with a serious absenteeism problem undertook a two-year study. She took a random...

19 Name: ____________________________________ 1. Your friend has a credit card with an APR of 49.9% ! What would his finance charge be on a $500 charge for just 1 month? 2. Your friend has 2 credit...

Math\t107-6381\t-\tQuiz\t#4\t-\tSchultz\t-\tDue\tFebruary\t21,\t2016\t-\tpage\t1\tof 3 Follow\tthese\tdirections\tcarefully. This\tquiz\tis\tdue\tby\t11:59\tEastern\ttime\ton\tFebruary\t21,\t2016. o...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

What is the wavelength of the radio waves transmitted by an FM station at 90 MHz? (Radio waves travel at 3.0 ( 10 8 m/s.)

Suppose F R R is continuous and suppose there are closed intervals Io, I such that F(Io) CI F(1) C Io. a. Show that F has at least one periodic orbit {x0, x1} of period q = 2 such that xo E Io and x ...

For positive constants of K, T1, and T2, a control system is described by its loop transfer function as Considering gain K = 0.06, compute phase margin and gain margin for (a) T1 = 5 and T2 = 2. (b)...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

6. Use an AD-AS graph to demonstrate and explain the pricelevel and real-output outcome of an anticipated decline in aggregate demand, as viewed by RET economists. (Assume that the economy initially...

1. Suppose that the money supply and the nominal GDP for a hypothetical economy are $96 billion and $336 billion, respectively. What is the velocity of money? How will households and businesses react...

5. An economy is producing at full employment when AD unexpectedly shifts to the left. A new classical economist would assume that as the economy adjusted back to producing at full employment, the...