Instructions
Use the information from the week 1 project assignment and add the following to it:
- Select a sample from the data: Use a random selection method, such as simple random selection or systematic random selection, to form your sample of at least 20 data points. The sample can be larger, but 20 is the minimum.
- List the original and sampled data points.
- Describe the sampling: Describe the sample size and how it was obtained. If you used a random selection method, describe what you did.
- Descriptive Statistics. Use Excel to do the following:
- Find the mean, mode, median, and standard deviation of your data set. You may include other calculations if they support your work.
- Create at least two graphs (such as box plots, scatter plots, stem-and-leaf, histograms, etc.) that depict the data.
- Interpret and explain your descriptive statistics and graphs. What do they indicate about the sample? Do they seem to support the claim you made in the Project, Week 1?
Upload your assignment, including your Excel spreadsheet, following the submission instructions found below.Some Rubric
Some Rubric
| Criteria |
Ratings |
Pts |
|
This criterion is linked to a Learning OutcomeMTH140.P2.01 Sample Selection & Listing
threshold: 20.0 pts
|
20 ptsExemplary: A valid and appropriate random sampling method was used (e.g., simple or systematic). The sample includes 20 or more data points, all clearly listed and relevant. Sampling reflects a good understanding of randomness and unbiased selection.17 ptsProficient: A random sampling method was used and described. Sample meets the size requirement and data points are mostly relevant and listed clearly.
14 ptsMarginal: Sampling method is vaguely described or somewhat flawed. Sample may be too small or list is incomplete or unclear.13 ptsWeak: Sampling method is missing, invalid, or sample is too small. Data points are not listed or are unclear.0 ptsNo credit |
20 pts
|
|
This criterion is linked to a Learning OutcomeMTH140.P2.02 Sampling Description
threshold: 15.0 pts
|
15 ptsExemplary: Clearly and accurately describes how the sample was selected, including the method used and its justification. Explanation demonstrates strong understanding of sampling principles and is free of ambiguity.13 ptsProficient: Sample method is described with minor omissions. Justification is adequate and shows a good understanding of random sampling.
11 ptsMarginal: Sampling process is briefly mentioned but lacks clarity or detail. Shows limited understanding of proper sampling.9 ptsWeak: Little description of sampling process or explanation is incorrect.0 ptsNo credit |
15 pts
|
|
This criterion is linked to a Learning OutcomeMTH140.P2.03 Descriptive Statistics Accuracy
threshold: 20.0 pts
|
20 ptsExemplary: Excel is used correctly to calculate all required descriptive statistics (mean, median, mode, standard deviation). Calculations are accurate and well-organized. Additional appropriate statistics may be included to enhance the analysis.17 ptsProficient: Most statistics are calculated correctly using Excel. Minor errors may be present but do not significantly affect interpretation.
14 ptsMarginal: Some statistics are missing or contain calculation errors. Excel is used inconsistently or incorrectly.13 ptsWeak: Descriptive statistics are missing or mostly incorrect. Excel is not used effectively.0 ptsNo credit |
20 pts
|
|
This criterion is linked to a Learning OutcomeMTH140.P2.04 Graphical Representations
threshold: 20.0 pts
|
20 ptsExemplary: Two or more appropriate graphs are included in the Excel file. (e.g., box plot, histogram, scatter plot). Graphs are clearly labeled, easy to interpret, and accurately reflect the data. Graph types suit the variable type and show thoughtful visual design.17 ptsProficient: Excel graphs are appropriate and mostly clear. Minor issues in labeling or graph selection may exist but do not impair understanding.
14 ptsMarginal: Excel graphs are incomplete, mislabeled, or only loosely related to the data. Only one graph may be present or appropriate.13 ptsWeak: Graphs are incomplete, inappropriate, or not in Excel. Little effort to visually represent the data accurately.0 ptsNo credit |
20 pts
|
|
This criterion is linked to a Learning OutcomeMTH140.P2.05 Interpretation & Communication of Results
threshold: 15.0 pts
|
15 ptsExemplary: Student provides a clear, thoughtful interpretation of the descriptive statistics and graphs. Explanations connect the visual and numerical data to the initial claim or question. Demonstrates excellent understanding of statistical meaning and relevance.13 ptsProficient: Interpretation is mostly clear and accurate. Shows good understanding of statistical meaning but lacks depth or detail in explanation.
11 ptsMarginal: Interpretation is unclear or only loosely tied to the results. Limited explanation of how statistics or graphs support the claim.9 ptsWeak: Little meaningful interpretation provided. Explanations are incorrect or show little understanding of statistical meaning.0 ptsNo credit |
15 pts
|
|
This criterion is linked to a Learning OutcomeMTH140.P2.06 Excel File
threshold: 10.0 pts
|
10 ptsExemplary: The submitted Excel file is complete and well-organized. All required calculations are correctly implemented using appropriate formulas/functions. The file demonstrates strong attention to detail, including consistent formatting, use of cell references, and logical organization of content.9 ptsProficient: The Excel file includes all required calculations with only minor errors in formula use or organization. Formatting and cell referencing are generally correct, with only occasional inconsistencies that do not significantly impact readability or interpretation.
8 ptsMarginal: The Excel file includes most required calculations but may contain some errors in formula use or cell references. Organization or formatting may be inconsistent, making parts of the file harder to follow, but the overall content is present.7 ptsWeak: The Excel file is missing several required calculations or contains major errors in formulas. File organization and formatting are inconsistent or unclear, making it difficult to interpret the work.0 ptsNo credit |
10 pts
|
Total Points: 100
Requirements: please look at the rubric
WRITE MY PAPER
Leave a Reply
You must be logged in to post a comment.