PLEASE FOLLOW THESE GUIDELINES CAREFULLY. MISSING ITEMS WILL REDUCE THE GRADE
OF THE PAPER. IF YOU HAVE ANY QUSTIONS PLEASE SEE ME OR ASK IN CLASS FOR
CLARIFICATION.
Please organize the paper in TWO parts. At the top of every page put your name, date, Math
114W and QC ID#. Each page should be double spaced with 1-inch margins all around.
PART I. (Tables, graphs, spreadsheets, etc.) (3+ pages; see #6 below)
(1) In the first few chapters we saw how data collected can be organized and displayed in various formats.
Dont forget to consider any possible outliers by noting them in the paper and perhaps removing them from
calculations.
(2) You must organize the raw data into a grouped frequency data table (with 8-10 appropriate classes.) Add
columns as we did in class to show limits, boundaries, marks, and percentiles as well as other columns you
might need for intermediate calculations.
(3) Display the grouped data as a histogram and a frequency polygon graph (no cumulative frequency polygon
required). Also, see if you can figure out a way to display the data so that the display might give an incorrect
conclusion of what the data indicates.
(4) Calculate the mean, median and standard deviation (mode not required) for both the raw data and the
grouped data. If you use software, web sites, etc. use a footnote to cite what software, site, etc. was used. Be
careful that your statistical results are in line with the raw data.
(5) Based on what we did in class (and perhaps any ideas of your own that you might have) calculate other
statistics you think might be useful.
(6) In a casual narrative fashion (understandable to a non-statistics person) explain your steps in what you
are trying to accomplish in the above and the mathematical steps you used. Include tables, graphs and
results as appropriate in your narrative. DO NOT INCLUDE THE RAW DATA OR ANY CALCULATIONS BUT ONLY
THE FINAL RESULTS AS MENTIONED IN 2-5 ABOVE. For the table(s), histogram, and graph use EXCEL or any
other software/web site you are comfortable with. Cut and paste any results as necessary.
PART II. (3+ pages)
This part of the paper is a NARRATIVE and should have a beginning, a middle and an end; see
a,b,c below. Do not repeat any of the narrative from PART I. Again, it should be understandable to
a non-statistics person.
(1) By using the data as a guide, design an appropriate experiment that might yield the raw data as actual
sample of some (perhaps fictional) population. For example, you might be measuring the height of
Martians in Mars capital city, Trumpville. Or you might be trying to measure the average income of the
population of slithy toves in the country of Jabberwocky. These are only (weird) examples. Different people
might use the same raw data to design different experiments. Explain in detail how you went about
choosing/collecting the data to make it a truly random yet representative sample of your population.06936 Topic: raw data excel statistics project
Number of Pages: 2 (Double Spaced)
Number of sources: 1
Writing Style: APA
Type of document: Statistics Project Academic
Level:Undergraduate
Category: Mathematics
Language Style: English (U.S.)
Order Instructions: Attached
Leave a Reply