blog15: how to insert statistics formula in google form
DESCRIPTION
TRANSCRIPT
How to insert statistics formula
in Google Form
By Kroo Jade
Click here
1. SIGN IN
2. Click and choose.
2. Click here
1. You can change the file name.
1. Select 5 rows (No.2-6).2. Right click.3. Choose insert 5 above.
2. Mode1. Mean
3. Median 4. SD
5. Percentage
1. Click here
2. Click and choose.
D E F
2 Mean =average(E8:E208) =average(F8:F208)
3 Mode =mode(E8:E208) =mode(F8:F208)
4 Median =median(E8:E208) =median(F8:F208)
5 SD =stdev(E8:E208) =stdev(F8:F208)
6 Percentage =E2*20 =F2*20
7
8
1. Change text color (Row No.2-6)2. Fill color (Row No.2-7)
Delete row No.8-12
Click and choose.
Test
Test
TestClick here
Thank you.