Lab 2 Homework (Standard Errors) SP24RR

.docx

School

Michigan State University *

*We aren’t endorsed by this school

Course

201

Subject

Mathematics

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by EarlIceBadger44

ISB 201L –Standard Deviations, Standard Error & Graphing Assignment [20 pts] For this assignment we are going practice calculating Standard Deviations, Standard Errors, and plotting Error Bars on Bar Graphs. We will first learn how to calculate deviations and errors by hand, and then use an Excel spreadsheet for our calculations. You are also required to import your excel graphs for this assignment, and There are tutorials posted in D2L (Tutorials folder) to assist with navigating Excel and creating Graphs and Error Bars. Upload your completed work to the designated dropbox prior to the beginning of next class. Prior to uploading, be sure that your work saved! In other words, double-check that you haven’t uploaded a blank document. It will be helpful if you use blue font for all of your answers. Step 1: Calculate Standard Deviation Watch the YouTube video titled ‘Standard Deviation’ by Paul Andersen. If the link does not work you can search for the video using the key words ‘Standard Deviation Paul Andersen’. This video is 7:49 minutes. 1. What is standard deviation ‘conceptually’? (1 pt) Standard Deviation conceptually measures the spread or variation in curves, or data. 2. Which of the following two graphs will have a greater standard deviation? Explain why. (1 pt) Graph B would have a greater standard deviation because it is more spread out. 3. Between minutes 6:00-6:25 of the video, Mr. Andersen introduces a practice problem. Pause the video here and calculate the standard deviation by hand. Show all work in the space below. (2 pts) Calculating the standard deviation by hand, I first added up all of the numbers presented and then divided it by the number of numbers which was five. I then went ahead to subtract to find the square roots of each problem, to which it came down to x-x(with the line over it) divided by n-1 to then get my answer, 2.7. 4. Continue the video to learn how to calculate standard deviation using Excel. It will be helpful to have an Excel spreadsheet open at this time! When finished, mark the box that best describes your experience with Excel. A B I use excel often, and very comfortable with using formulas in excel. I have used excel, but not comfortable using formulas in excel. I have never used excel.

Step 2: Calculate & Plot Standard Errors Watch the YouTube video titled ‘Standard Error’ by Paul Andersen. If the link does not work you can search for the video using the key words ‘Standard Error Paul Andersen’. This video is 7:04 minutes. 5. Pause the video at minute 5:45 and calculate the Standard Error (SE) of set 1. Use Excel to calculate the standard deviation, but calculate the standard error by hand. Show all work in the space below. (2 pts) I had a hard time calculating the standard error by hand on this one, not sure why but I couldn’t get 3 as my answer. 6. Complete the bar graph started in the video. Include the means, and standard error bars for both data sets. Label as much as you can. There are tutorials for how to add error bars in Excel in the Tutorial folder. You will be importing the completed graph directly from Excel. (2 pts) 7. Which data set has the greatest standard error? Explain what this tells us about the averages (means) in comparison to all the values within that data set? (2 pts) Set 1, the one I calculated has the greatest standard error. This tells us that when you have a larger average number, and less numbers in the data set, that the standard error will be larger. 8. Describe a basic research question and data sets where standard errors can be calculated. (2 pts) One research question and data sets where a standard error can be calculated could be, this number of students on these days showered after gym class, and this number on these days did not.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help