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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!