Math-Q1 Lab ~ Stock Trends

Calculus A 2015-2016 Q1 Lab ~ Stock Trends

Due Date: December 9, 2015(at the start of class period)

Group members names (Groups of 3): _____________________________________________________

Lab Objective: To create a function that models the performance of a stock for a company by using data for approximately 18-month period & to use CALCULUS concepts to evaluate various aspects of the stock’s performance.

Data: Select a company that models an increasing/decreasing cyclical trend (Note: if need be, your group can modify, the value of the monthly stock.) (NOTE: Each team must have a different company). Go to Yahoo.com and find the Finance Section. In the “Get Quotes” box search for your company. Then under the Quotes tab, select historical prices and set a date range to give you 18 pieces of data (18 months), beginning with the most recent month and going back.

NOTE: Before you begin the lab, it would be advantageous to read & review as a TEAM the Sample Lab posted on ProgressBook.

Final Report: Using the following questions as a guideline, type your lab report (NOTE: math calculations can be NEATLY written) & present it in an ORDERLY/ORGANIZED manner. The graphs must be imported from Excel or TI-Connect within the appropriate spot in the lab. You should include a cover page with all members’ names included. PLEASE BE NEAT!

Lab Report Questions

1) In a few, clearly expressed sentences, describe your product/company, its historical trend on the Stock Market, its current trend in the Stock Market, and your group’s subjective thoughts on these behaviors. Using the data provided, identify 12-18 pieces of data (Oldest Date vs. Stock Price) where x=1 is your oldest month and your points continue with x = 2, etc. In your final report, you must include a table showing these vales. NOTE: If your group modifies any numbers, this would be an additional column represented in the data table.

2)...