![]() Refer to the Analyzing the Data Set Using Descriptive Statistics Scoring Guide before submitting to ensure your assignment meets the grading criteria.Make sure you have watched the Week 7 Project Video. Note: Excel 2016 now has an available Toolpak add-in. Include a 1–2 paragraph summary of your findings. Mac users: StatPlus: Mac LE is the free equivalent for Apple users, but you must download it from AnalystSoft. Two tables, graphs, or charts to represent interesting findings from your survey responses.Integrating tightly with Microsoft Excel, StatPlus:mac empowers. Two histograms, one each for questions 5 and 6. StatPlus:mac offers you an ability to perform heavy-duty data analysis on your Mac in a familiar and convenient Excel environment.Four bar graphs (or four pie charts), one each for questions 1–4.Verify you have included all of the elements for Parts 1–3 before submitting.Format your findings with appropriate, legible labels. When you have completed this assignment, submit your Excel spreadsheet containing Parts 1–3, to your instructor in the Analyzing the Data Set Using Descriptive Statistics Assignment area.It is up to you which response to assign 0 and which to assign 1. For example, if you asked: “Are you male of female?” you could assign Male = 0 and Female = 1, or vice versa. Assign 0 to one of your possible responses and assign 1 to the other possible response. ![]() A histogram is a bar chart in which the heights of the bars represent the. The tool does not know your questions or possible responses for these questions. Breakout 5 Transcript of the histogram screencast (StatPlus:mac LE). The generator automatically generates 0s and 1s for the responses to your binary questions (1–4). StatPlus creates a matrix showing pairwise correlations, equivalent to Excel's CORREL and PEARSON worksheet functions and equivalent to results of the Windows Excel Analysis ToolPak. Binary Question: For the responses to Questions 1–4, you will need to assign the survey responses to 0s and 1s generated for questions 1–4 in columns A through D. For correlation using StatPlus:mac LE with Excel 2011, choose StatPlus > Statistics > Basic Statistics and Tables > Linear Correlation (Pearson).Your task is to analyze, interpret, and communicate the unique results. Results: Because the survey data generation is done without context, you will have to put aside any preconceived notions about how your data should look.Be sure you keep a copy of your original data file as a backup. Technology: You may need to sort or rearrange your original data file to accomplish some of these tasks.Then, write in the same Excel spreadsheet a 1–2 paragraph summary of your findings. ![]() Present your findings in an appropriate table, graph, or chart. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |