The purpose of this assignment is to practice organizing data through ordering and grouping variables. Data often appear disordered and it is difficult to see any connections or relationships. Ordering the data by certain variables or grouping variables into specific categories, such as age or sex categories, can help bring clarity to the data. Knowing how to organize data is an important skill to initiate the analytical process. For this assignment, students will use Excel and SPSS Statistics to order variables. Using the Example Dataset, complete the steps below using both Excel and SPSS Statistics. View the Excel and SPSS tutorials for assistance in completing this assignment. Submit one Word document and include a screen shot of the data after completing the first two steps of Part 1 in Excel and SPSS to compare your results. Use a second Word document to complete Part 2 of the assignment. Part 1: Ordering and Grouping Data Using Excel and SPSS For Part 1, accomplish the following: Order (sort) observations according to age. Group observations by sex and investigate the age and income for males and females. Create a new variable titled Exercise Group based on the variable Minutes Exercise. Use the following categories to create your groups: 1 = 0-30 minutes; 2 = 31-60 minutes; 3 = 61-90 minutes; 4 = 91-120 minutes; and 5 = 120+ minutes. Part 2: Data Interpretation Study the results of the dataset grouping and ordering. Discuss the following in a 500-750 word summary: Describe the measurement levels for each of the variables in the dataset. Discuss what you learned from ordering the data by age and why this information is important. Describe the process you used to group the data in Excel and SPSS. Describe what you learned by grouping the variables by category of exercise. Are these data from a correlational study, experimental study, or quasi-experimental (observational) study? Discuss your rationale and identify a study question appropriate for this dataset. General Requirements Submit the Word document to the instructor. APA style is not required, but solid academic writing is expected. This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Why Choose Us
High Quality, 100% Original and Well-Researched Papers
HireProWriter always ensure that our writers follow all your instructions precisely. You can pick your academic level: high school, college/university or professional, and we will assign a writer who much your field or discipline.
Professional and Experienced Academic Writers
Our Company has a team of professional writers with experience in business articles and academic papers. The majority are native speakers and capable to tackle any task for which you need assistance.
Free Unlimited Revisions
Do you think we missed something on your paper? No worries, send your order for a free revision. We give you up to 10 days to submit the order for review after you have received the final document. You can do this yourself after logging in to your account or get help from our support.
Prompt Delivery and 100% Money-Back-Guarantee
All papers are always delivered on time. In case we need an extension to master your paper, we will contact you on time regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & Confidential
100% Plagiarism free work! We use premium writing tools to check plagiarism. Our professional editors carefully review all quotations in the text. Besides, we guarantee maximum confidentiality in all of our services.
Customer Support 24/7
Our support team is available 24/7. We are dedicated to giving the best customer experience. Feel free to get in touch any time for assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Why work on your paper all night? While you can sleep tight, as we cover you back. HireProWriter offer all kinds of writing services.
No matter what kind of academic assistance you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at a reasonable cost. HireProWriter take care of all your academic paper needs with a 24/7 customer care support system.
Admission and Business Papers
An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You don't have to worry about writing a presentable College admission essay, You can be rest assurred that through our services we will write the best admission essay for you.
Editing and Proofreading
Our Team (academic writers and editors) make the necessary adjustments to your essay/paper so that it is polished. Besides, we format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.
We value our clients feedback, our system is designed to ensure that we deliver quality work through collaboration of our team and clients. In case you need an improvement in your paper, you are free to request for revision. For such case, your paper will be checked by the writer or assigned to an editor. Your Satisfaction is our Concern!