A4 requires the use of a spreadsheet application program, (e.g., MS Excel) to input, organize, and conduct basic univariate and bivariate analysis of the provided data. It concludes with a set of questions, some of which are based on the data and analysis represented within the generated spreadsheet file. Step 1 ? Create a spreadsheet file, and then create two separate worksheets (tabs at bottom) within this file, name one “Paired” and the other “Independent”. Enter the data from Table 1 into the “Paired” worksheet and the data from Table 2 into the “Independent” worksheet. Conduct all analysis of these data sets within these worksheets ensuring to format and label things in such a way as to ensure clear identification of each part in a visually appealing way. o Save your spreadsheet file as “A4-. Do not use spaces in the file name. As an example, in my case I would name the file “A4-AK.” o This assignment requires the use of two separate worksheets within the spreadsheet file (Note. Tabs at the bottom of the worksheet page, right click over them and …), label each one respectively: • “Paired” and “Independent” Step 2: Working with a “Paired Samples” data set ? Provide all solutions to the following within the “Paired” worksheet. It is up to you to ensure each solution (or answer to a question) is easily found and identified within the worksheet. The use of colors, bolding, lines, etc., can help create an organized worksheet. ? The data provided in “Table 1 – Paired Samples” is the same data as used for Assignment 3 (A3), thus, you can reference your previous work with A3 for all the descriptive statistics and charts related to this data set. Include each of the following items, clearly labeled, within the worksheet. 1. 2 pts: Indicate an appropriate Ho for a means comparison test of the pretest and posttest scores. 2. 2 pts: Indicate an appropriate Ha for a means comparison test of the pretest and posttest scores. Conduct the appropriate t-test analysis within the Excel worksheet. 3. 6 pts: Formally state the results from your analysis. The following items should be included within this statement: o Mean o Standard Deviation o Calculated t statistic o Degrees of freedom (df) o A reference to whether the p-value is < or > the alpha value. Assignment 4 (A4) Page 3 of 4 Step 3: Working with an “Independent Samples” data set ? Provide all solutions to the following within the “Independent” worksheet. It is up to you to ensure each solution (or answer to a question) is easily found and identified within the worksheet. The use of colors, bolding, lines, etc., can help create an organized worksheet. 4. 1 pt: Data Table (includes all the provided raw data from Table 2) o Clearly labeled, includes all the provided data sorted in ascending order by group. o Data entered without errors. 5. 2 pts: Class Interval Table that includes both Group 1 and Group 2 separately. This means you will have three columns within the table, they are: Range, Group 1, and Group 2. o REQUIRED – Must make use of the array function “FREQUENCY.” o It is up to you to establish interval ranges (bins) that do a good job of communicating the distribution of the data. Recall from Assignment 3 we used bin sizes of “2” and they were set up as: <18, 18.1-20, 20.1-22, 22.1-24, etc. With this data set, you may want to establish larger ranges for each bin, perhaps 3, or 4, or 5, or 6, etc. – you decide. ——————————————————————————- 6. 2 pts: Histogram Chart (includes both Group 1 and Group 2 data graphed separately but within a single chart) o Create a histogram chart of the data from the “Class Interval Table.” • Note. A histogram is really a column chart, with each column representing a frequency count of data points within a specific range (also called a “bin”). Think back on your “Class Interval Table,” each interval is a bin, and you are interested in graphing the number of data points that fall within each bin. —————————————————————————— 7. 5 pts: Descriptive Statistics – Calculate the following descriptive statistics for Group 1 and Group 2. Mean Standard Error of the Mean Median Mode Standard Deviation Variance Kurtosis sek Skewness ses Range Minimum Maximum Sum Coun
Need Help Writing an Essay?
Our team of talented writers is ready to assist. We offer essay writing help in over 75 disciplines, ensuring a convenient and comprehensive solution for all your academic needs!
Get Help Now!Get Quick Assignment Writing Help – No Plagiarism Guarantee!
Online assignment writing service website that provide university students with original and quality academic essays, term papers, admission essays, annotated bibliographies, reports, scholarship essays, personal statements, research proposals, research papers, projects, presentations, dissertation, theses, movie reviews, Book reviews, application papers, among others.
Having trouble with a homework question? Our skilled assignment writers are here to provide answers to all types of queries, ranging from fundamental mathematics to cutting-edge rocket science!
