Question: Using Excel and SPSS Input the data into an excel spreadsheet and calculate the Mean, standard deviation and standard error of the mean for each
Using Excel and SPSS
Input the data into an excel spreadsheet and calculate the Mean, standard deviation and standard error of the mean for each outcome
| A | B | C | |
| 1 | Head | Tail | |
| 2 | Round 1 | 5 | 5 |
| 3 | R 2ound | 4 | 6 |
| 4 | Round3 | 5 | 5 |
| 5 | Round4 | 3 | 7 |
| 6 | Round 5 | 5 | 5 |
| 7 | Average | ||
| 8 | Standard Deviation | ||
| 9 | Standard Error of the mean |
| Head | Tail | |
| mean | ||
| Standard Deviation | ||
| Standard Error of the mean |
Produce an appropriate graph with error bars using standard error of the mean (on Excel)
Paste graph here
Input the data to SPSS and produce a graph with SEM error bar.
Paste output window here (See Biomeasurement text book for further support)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
