代做Stats Project: Financial Stock Advisor调试数据库编程

Stats Project:  Financial Stock Advisor

Scenario: You are a financial advisor who is looking to recommend a stock to clients via a podcast/vlog. You will work with your team (you plus 2) to research a total of 3 stocks and create a podcast/vlog that delivers an analysis of the data you collected.

You will include visual representations and use your analysis to inform. possible clients ofthe best choice, if any, of the researched stocks.

Part I:  Finding the Data

a)  Go to “Yahoo Finance” at https://finance.yahoo.com on the computer and search  for a company that has been publicly traded since 2014. (Use the search bar at the top of the website if you have a company in mind.) On the site, select “historical data” and look at the stock prices for the same date of each year.  In the table below, write down the day’s high and low price. Then calculate the mean (average) price for each date.

GROUP STOCK THEME: __________________________

Name of Stock: ______________           Stock Symbol: __________

x-coordinate (Pick a specific month and day)	High Price	Low Price	Average Price (y)	(x, y)
(1) , 2014
(2) , 2015
(3) , 2016
(4) , 2017
(5) , 2018
(6) , 2019
(7) , 2020
(8) , 2021
(9) , 2022
(10) , 2023
(11) , 2024

Part II: Statistics

b)  Find the following measures of your average prices.

mean = _____    median = _____     mode = _____    range = _____    S.D. = _______

Which measure do you think best represents your data?  Write a few sentences explaining why.

c)  Calculate the 5 values for a box and whisker plot, then draw the plot.

(Use online programs to help.)

least = ________                 1st  Quartile = ________                 median = ________

3rd Quartile = ________                 greatest = ________

d)  Are there any outliers?  Use the interquartile range to justify your answer (show your work).

e) Do you need to create a new box plot and look over the information again because of outliers? If so, then do it.

Part III:  Graphing and Prediction Equations

f)  Draw a coordinate plane on graph paper or Desmos and plot your (x, y) ordered pairs from the table on the front page.

g)  On your graph paper, draw a horizontal dotted line representing the average price of the stock for the last ten years.

h)  Do at least 3 different types of regressions for your data (you can use Desmos). Write down each equation and graph them with your data.

i)  Use each equation to predict the value of your stock for the month and day you selected, 2030.  Show your work and write your answer below.

j)  Which prediction makes the most sense to you?  Write a few sentences about this.

Part IV:  Analysis

Directions: As a group of financial advisers.  One of your advisees comes to you and asks about investing in the companies you researched.  Create a podcast/vlog for your advisee explaining why you would or would not recommend the researched companies.  Include the following information.

--Description of your company. What does the company do?  How big is it (what is their market cap)?

--Name some companies that are similar to your company.

--Future predictions for the stocks

--Recommendation to buy or not to buy (use your data to support your answer )

(This should be in your own words, not cut and pasted from a website. Keep in mind how you are being assessed. You should include proper citation of any sources and  submit your script for the podcast/vlog).

Example: Apple Stock (AAPL)

x-coordinate	High Price	Low Price	Average Price (y)	(x, y)
(1)  May 1, 2011	12.57	11.77	12.17	(1, 12.17)
(2)  May 1, 2012	21.31	18.65	19.98	(2, 19.98)
(3)  May 1, 2013	16.63	14.96	15.80	(3, 15.80)
(4)  May 1, 2014	23.01	20.73	21.87	(4, 21.87)
(5)  May 1, 2015	33.24	30.84	32.04	(5,
(6)  May 1, 2016	25.18	22.37	23.78	(6,
(7)  May 1, 2017	39.16	36.07	37.62	(7,
(8)  May 1, 2018	47.59	41.32	44.46	(8,
(9)  May 1, 2019	53.83	43.75	48.79	(9,
(10) May 1, 2020	81.06	71.46	76.26	(10,
(11) May 1, 2021	134.07	131.83	132.95	(11,