Instructions

/in /by

Home>Homework Answsers>Nursing homework helpInstructionsIn this assignment, you will be required to calculate descriptive statistics for each numeric variable in the Heart Rate Dataset.StepsOpen the Heart Rate Dataset in ExcelSort the quantitative variables by class (e.g., Male at-rest heart rate and Female at-rest heart rate)Use the Excel Data Analysis ToolPak* tools to calculate each of the following statistics:Mean of each quantitative variableSample variance of each quantitative variableSample standard deviation of each quantitative variableCreate a table in Excel that summarizes the statistics for each variable.Transfer your summary results to Word.Interpret what the mean and standard deviation specifically tell you about the heart rates of males and females in the sample.  Are the heart rates for males or females higher?  Which data is more spread out, and which is closest to the overall mean rate? Explain your responses.In the topic “Measures of Center,” you were provided directions on how to upload the Data Analysis ToolPak to Excel. If you have not yet uploaded the add-in Data Analysis ToolPak, please view the appropriate video and follow the instructions.  You will not be able to complete this assignment without that add-in.How to Install the Data Analysis ToolPac in Microsoft Excel(Quantitative Specialists, 2013)Estimated time to complete: 2 minutesHow to Add the Data Analysis ToolPak in Excel on Mac 2018(Ben G. Kaiser, 2018)Estimated time to complete: 2 minutesInstalling Excel Toolpak (Data Analysis) on Mac (versions other than 2018)(Joseph C., 2016)Estimated time to complete: 1 minuteFor a review of how to use the Data Analysis ToolPak to create summary statisticsReview: Descriptive Statistics in Excel Mean, Median, Mode …Directions: Review this video on how to use the Data Analysis ToolPak to create summary statistics.(Joshua Emmanuel, 2017)Estimated time to complete: 1 minuteAdditional Instructions:Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must includeRunning headA title page withAssignment nameYour nameProfessor’s nameCourseEstimated time to complete: 3 hoursReferencesBen G Kaiser. (2018).  How to add the Data Analysis ToolPak in Excel on Mac 2018 [Video]. Retrieved from https://youtu.be/HJay_paA6T4Joseph C. (2016). Installing Excel Toolpak (Data Analysis) on Mac [Video].  Retrieved from https://youtu.be/mtmrAXwLcuUJoshua Emmanuel. (, 2017). Descriptive statistics in Excel mean, median, mode, std. deviation… [Video]. Retrieved from https://youtu.be/qJR8OMQP3vw/p>Quantitative Specialists. (, 2013). How to install the Data Analysis ToolPak in Microsoft Excel [Video]. Retrieved from https://youtu.be/_yNxLFagKgwAssignment FilesHeart Rate Data Set[Excel Document]5 years ago20.11.202015Report issueAnswer(2)Wendy Lewis4.7(19k+)4.8(3k+)ChatPurchase the answer to view itUnit_3_Descriptive_Statistics.docx5 years agoplagiarism checkPurchase $15Smart Study3.4(425)3.1(5)ChatPurchase the answer to view itNOT RATEDUnit3Assessment-DescriptiveStatistics.docx3 years agoplagiarism checkPurchase $8.99Bids(82)Dr Michelle MayaTutor Cyrus KenWIZARD_KIMRosie SeptemberEmily MichaelProf James KelvinNightingaleAmanda Smithwizard kimAshliey WriterElprofessoriProCastrol01Dr shamille Claraprof bradleyProfRubbsbrilliant answersBrainy Brianmichael smithPROF. ANNSTANWRITTERother Questions(10)research applicationpowerpoint slidesFinance AssignmentCASH FLOW 2244ANALYZING MANAGERIAL DECISIONS 2212EFFECTIVE PRESENTATIONS 2165SETTING UP A BID 2162ITM301 SLP 4 2155STRATEGIC MANAGEMENT 2071AT&T 2057

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now