The purpose is for you to find a secondary data set, create variables, and enter the data in excel. Upon completion of this assignment, you should be able to find and download free, public, secondary
Assignment-Data Mining and Analysis
Use the data you downloaded and organized in part 1 to complete the following analyses in Microsoft Excel. You have been provided with instructional videos and tutorials by the professor to complete this assignment. Your rubric is attached.
For this assignment, you are only conducting data analysis. You will interpret the results in the next assignment.
Directions: Use 1 Excel file to complete all analyses. Complete each analysis on a different sheet. Note: Excel files have different sheets at the bottom of the page. Rename each sheet by the title of the analysis you are completing (example-change sheet 1 to Independent T Test)
Conduct the following statistical analyses in Excel
Independent T-Test
T-test
Pearson’s Correlation Test
ANOVA
Chi Square Test
Assignment-Data Mining and Analysis Rubric
| Organization & Formatting | Information is very well organized by using appropriate variables and labels, as well as the appropriate advanced formatting, including shading, alignment tools, borders, special fonts, and appropriate column/row height & width | Information is mostly organized by using appropriate variables and labels and the appropriate formatting | Some Information is organized, using standard formatting tools. Some labels or other important formatting tools are missing. | 25 |
| Computations & Formulas |
|
|
Incorrect use of applicable formulas as required | 35 |
| Directions | Followed all directions accurately and fully completed the assignment | Followed most of the directions accurately and fully completed assignment | Did not follow any of the directions or, Followed some directions but missed many of the details required | 20 |
| Data Entry | Successfully entered all data correctly | Entered almost all data correctly with minor to no corrections needed | Data entered but major corrections needed Several errors noted Data missing | 20 |
