аЯрЁБс>ўџ 68ўџџџ5џџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџьЅС7 №ПbjbjUU "7|7|џџџџџџlиииииии$тттт ю$2ŸŸŸŸŸŸ$P pОУиУ$иии$$$ ии$$і$:Й,ииA  `4)|ъrЫ$От  х A\ю0яR.*њ.A$ь иииийLinear Regression – An 80-Year Study of the Dow Jones Industrial Average For decades, the prevailing opinion in the field of finance has been that, given a long investment horizon (30 years or more), the best results will be achieved through investment in the common stock of publicly sold corporations. It is often cited that the long-term average annualized return of the broader stock market is between 10% and 12%. That percentage has changed slightly over time depending on who is citing it and when it is being cited. However, if you had purchased a diversified basket of stocks of domestic corporations at any point during the middle of the 20th century and held them for 30 years, you would have achieved an average annualized return somewhere in this range. The index that is commonly used to indicate the health of the broader stock market is the Dow Jones Industrial Average (DJIA). The Dow is made up of 30 large-cap (blue chip) companies. The DJIA is calculated by summing the stock prices of these 30 companies and then adjusting that sum for stock splits or other structural changes to the companies’ shares. The result is a dollar value that generally fluctuates in unison with the broader market. We use the DJIA to give us a sense of how the overall stock market is faring at any given point in time. Your goal in this project is to study the trend in the DJIA since 1930 and create an appropriate model. You will be using Microsoft Excel to create a spreadsheet and appropriate displays of the data. Collect data on the DJIA—Research the Dow price for the month of July (any date near the beginning of the month is fine) in each year from 1930 to 2010. Enter them into an Excel Spreadsheet with a column for the years and a column for the Dow prices. Scale the years appropriately. Create an appropriate display to show the trend in the DJIA over the past 80 years. Answer question #1. Create a linear model to predict “DJIA price” from “Years Since 1930”. Include the model in your display. Answer questions #2, 3, and 4. Create a column for predicted Dow Prices and fill it with the predicted price for each year based on your model. Create a column for residuals and fill it with the residual for each year. Create a residuals plot. Answer question #5. Perform transformations on the Dow Prices until you find an appropriate one that makes the plot look more linear. Create a column in your spreadsheet for these transformed values, give it an appropriate heading, and fill it with the transformed price for each year. Create a new display of your transformed data. Create a linear model for the transformed data and include the model in your display. Answer questions #6, 7, and 8. Create a column for predictions made by your new model, give it an appropriate heading, and fill it with the appropriate predicted values. Create a column for residuals and fill it with the residuals for each year. Create a residuals plot. Answer question #9. Calculate the correlation coefficient, r, and the R2 value for your transformed data. Answer questions #10 and 11. Answer questions #12 and 13. Use Microsoft Excel to fit an exponential curve to the original data (Dow prices vs. Years Since 1930). Answer questions #14, 15, and 16. Answer question #17. The top row of your spreadsheet should look like this: Year Since 1930Dow PricePredicted Dow PriceResiduals(Appropriate Transformation Which You Have Chosen)(Predictions Based on Your Transformation)(Residuals From Your Transformation) IJŽC G “ Ÿ i t іїv‡<Muјљ§ћљљљћљыйЧТCJaJ#5B*CJOJQJ\^JaJphџf#5B*CJOJQJ\^JaJphџ5CJOJQJ\^JaJ>*H*CJ4IJ4 6    ˆ ‰ Š      ABЙКЛТУ§ћћѕћћћяяъфъћфъфъћћъфъћфъф„а^„а & F„h^„h„а`„а§У789WXуфхњћќџ:;<BMWku‚Јгјњјђњђњјђњђјјјјјјјјщщщщщщщщщ $$Ifa$„а^„а & FјљњјFf 1hАа/ Ар=!А"А# $ %Аљ$$If”жДєџиR њ ^1G]$'фМџџџџ'LџџџџФџџџџ'dџџџџ`џџџџшџџџџ'дџџџџі0 6ж џџџџџџџџж џџџџџџџџџџџџџџџџџџџџџџџџџџџџџж џџџџџџџџж џџџџџџџџ2ж  2ж2ж  2ж2ж  2ж2ж  2ж2ж  2ж2ж  2ж2ж  2ж2ж  2ж4жaі i8@ёџ8 NormalCJ_HaJmH sH tH <A@ђџЁ< Default Paragraph Font.B@ђ. Body Text>*CJ4џџџџ џџ z™ џџ z™ =IJ46 ˆ‰Š   A B Й К Л Т У 7 8 9 W X у ф х њ ћ ќ џ   : ; < B M W k u ‚ Ј г ј љ ˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜ 0€€˜0€€˜ 0€€˜0€€˜0€€˜ 0€€˜0€€˜ 0€€˜0€€˜0€€˜ 0€€˜0€€˜ 0€€˜0€€˜0€€˜ 0€€˜0€€˜ 0€€˜0€€˜0€€˜ 0€€˜0€€˜ 0 €€˜0€€˜0€€˜ 0 €€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€˜0€€Љ0€€Љ0€€Љ0€€Љ0€€Љ0€€Љ0€€Љ0€€Љ0€€Љ0€€™0€€˜0€€ Уј  UVGz„…ўџЊ Ћ О П Т Т + , 6 8 J K V W в г т ф ѕ і ў   ; < љ ћ џџ -E:\AP Statistics\ExtraCredit_DJIA_Project.doc pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd pC:\Documents and Settings\Dave\Application Data\Microsoft\Word\AutoRecovery save of ExtraCredit_DJIA_Project.asd -E:\AP Statistics\ExtraCredit_DJIA_Project.docШ?LL fFџџџџџџџџџ<+С} 5маџџџџџџџџџh „а„˜ўЦа^„а`„˜ўOJQJo(З№h „ „˜ўЦ ^„ `„˜ўOJQJo(oh „p„˜ўЦp^„p`„˜ўOJQJo(Ї№h „@ „˜ўЦ@ ^„@ `„˜ўOJQJo(З№h „„˜ўЦ^„`„˜ўOJQJo(oh „р„˜ўЦр^„р`„˜ўOJQJo(Ї№h „А„˜ўЦА^„А`„˜ўOJQJo(З№h „€„˜ўЦ€^„€`„˜ўOJQJo(oh „P„˜ўЦP^„P`„˜ўOJQJo(Ї№h„8„˜ўЦ8^„8`„˜ў.h„„˜ўЦ^„`„˜ў.’h„и „LџЦи ^„и `„Lџ.h„Ј „˜ўЦЈ ^„Ј `„˜ў.h„x„˜ўЦx^„x`„˜ў.’h„H„LџЦH^„H`„Lџ.h„„˜ўЦ^„`„˜ў.h„ш„˜ўЦш^„ш`„˜ў.’h„И„LџЦИ^„И`„Lџ.Ш?L<+С}џџџџџџџџџџџџ                  < B M W k u Ј г ј љ –џ@€33и ­ЧЧ33@@џџUnknownџџџџџџџџџџџџG‡z €џTimes New Roman5€Symbol3& ‡z €џArial?5 ‡z €џCourier New;€Wingdings"ёˆ№аhъЛъЦъЛъЦ ЛъЦ !№ ДД~0/Š2ƒQ№џџHLinear Regression  An 80-Year Study of the Dow Jones Industrial Average  ўџр…ŸђљOhЋ‘+'Гй0И˜ є $4 @L h t € Œ˜ ЈАфILinear Regression – An 80-Year Study of the Dow Jones Industrial Averagehine neneneNormalR rm2rmMicrosoft Word 9.0 @Œ†G@€љаЯrЫ@tч[ъrЫ@tч[ъrЫ ўџеЭеœ.“—+,љЎ00 hp|„Œ” œЄЌД М ф r/  ILinear Regression – An 80-Year Study of the Dow Jones Industrial Average Title ўџџџўџџџ !"#$ўџџџ&'()*+,ўџџџ./01234ўџџџ§џџџ7ўџџџўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџ РFPб2|ъrЫ9€Data џџџџџџџџџџџџ1Tableџџџџџџџџ.WordDocumentџџџџ"SummaryInformation(џџџџџџџџџџџџ%DocumentSummaryInformation8џџџџџџџџ-CompObjџџџџjObjectPoolџџџџџџџџџџџџPб2|ъrЫPб2|ъrЫўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџ џџџџ РFMicrosoft Word Document MSWordDocWord.Document.8є9Вq