Weeks 13-16
STOCK PORTFOLIO PROJECT
Final Submission of PORTFOLIO FILE Due November 26, 2012
Snapshots:
(1) Correct all mistakes shown in the preliminary grading.
(2) Add a final section to the report consisting of a one-page table showing: (a) the mathematical models derived from the 24 months of month-end closing prices; (b) the coefficient of determination (R-squared); (c) a three-month price forecast using each model; and (d) a price forecast as of June 30, 2013 for each model. The links below provide the example shown in class on Friday (11/16). Finish this section by filling in the four blanks shown in the example. These additions will provide a two sentence conclusion for this final section of your snapshot. Consider saving your Excel work as a PDF. Then you can use the "Snipping Tool" to copy this work into your previous snapshot work.
Excel File of Example for Aflac, Inc
PDF File of Example For Aflac, Inc
Correlation Table:
Place the stock correlation table on the top of the file.
Previously Graded Work & Preliminary Grading Worksheet:
LEAVE THE PREVIOUSLY GRADED SNAPSHOTS & GRADING SHEETS IN THE FILE. Failure to do so will result in a significant deduction.
DATA ANALYSIS REPORT WRITING PROJECT
(Executive Summary Format)
FINAL REPORT Due Friday November 30, 2012
STUDENT DATA FOR PHYSICAL EDUCATION DEPARTMENT 2012 (No Names)
Here's descriptive statistics for the male and female subpopulations. Check the work of your group against these results.
PHYSICAL EDUCATION DESCRIPTIVE STATISTICS EXCEL FILE
Each group will perform the following tasks.
Step #1: Each group will produce a population data description for each quantitative variable shown in the data set. Each description will include a histogram that should comply with the standards shown on the whiteboard.
Mile Time Histograms (All, Male, Female)
Mile Time Describe Distributions (All, Male, Female)
Step#2: Each group has a team member dedicated to preparing parallel box plot displays for the four quanitative variable fitness tests (Mile Time, Curl Up, Push Up, and Body Mass Index). Each display will show a boxplot for the females only, and a boxplot for the males only. In case this work is not completed on time, generic displays are provided below that can be customized as a substitute.
Step #3: Data will be sorted by gender. Population comparisons (male vs. female) will be completed for each quantitative variable.
Compare Two Distributions Format
Step #4: Three pie charts will compare the pass rates for the two categorical variables.
Step #5: The components above are assembled in a single report using the format below. Team leaders will add the required text and take reponsibility for preparing the final report.
REPORT FORMAT WORD DOCX FORMAT
Graphics For Question #2: Generic Segmented Bar Graphs
Other Graphics For Question #2: Histogram Showing # of Tests Passed
Step #6: Leaders complete Team Evaluation form.
Teacher Assessment form sheet has be linked for your reference.