Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Google Sheets to calculate the average of your drop distance data. In the cell B2 type =AVERAGE(A:A) and hit enter. Record the value below.
Use Google Sheets to calculate the average of your drop distance data. In the cell B2 type =AVERAGE(A:A) and hit enter. Record the value below. 2. Use Google Sheets to calculate the standard deviation of your drop distance data. In the cell C2 type =STDEV(A:A) and hit enter. Record the value below. 3. Use Google Sheets to calculate the standard deviation of the mean of your drop distance data. In the cell D2 type =C2/SQRT(N) and hit enter. N is the number of trials for your experiment. Record the value below. 4. Use Google Sheets to make a histogram of your drop distance data. Select column A (click on the A in Google Sheets). Then go to Insert -> Chart. For Chart Type select Histogram Chart
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started