Standard Deviation Percentages In Excel.

Liparulo

New Member
Joined
Sep 12, 2009
Messages
5
Hello everyone,
I've been doing a Maths assignment and am unsure how to do the following question in Excel

If <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"> <o:lock v:ext="edit" aspectratio="t"> </o:lock><v:shape id="Picture_x0020_1" o:spid="_x0000_i1028" type="#_x0000_t75" alt="\bar{x}" style="width: 8.25pt; height: 9pt; visibility: visible;"> <v:imagedata src="file:///C:%5CUsers%5CLiparulo%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image001.png" o:title="bar{x}"> </v:imagedata></v:shape></v:path></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas></v:stroke></v:shapetype>'x' is the mean of the data and s is the standard deviation of the data,<v:shape id="Picture_x0020_4" o:spid="_x0000_i1027" type="#_x0000_t75" alt="\bar{x}" style="width: 8.25pt; height: 9pt; visibility: visible;"> <v:imagedata src="file:///C:%5CUsers%5CLiparulo%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image001.png" o:title="bar{x}"> </v:imagedata></v:shape><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"> <o:lock v:ext="edit" aspectratio="t"> </o:lock><v:shape id="Picture_x0020_1" o:spid="_x0000_i1028" type="#_x0000_t75" alt="\bar{x}" style="width: 8.25pt; height: 9pt; visibility: visible;"> <v:imagedata src="file:///C:%5CUsers%5CLiparulo%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image001.png" o:title="bar{x}"> </v:imagedata></v:shape></v:path></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas></v:stroke></v:shapetype>'x' [FONT=&quot]±[/FONT] s refers to the region of the data that ranges from <v:shape id="Picture_x0020_7" o:spid="_x0000_i1026" type="#_x0000_t75" alt="\bar{x}" style="width: 8.25pt; height: 9pt; visibility: visible;"> <v:imagedata src="file:///C:%5CUsers%5CLiparulo%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image001.png" o:title="bar{x}"> </v:imagedata></v:shape>-s to <v:shape id="Picture_x0020_10" o:spid="_x0000_i1025" type="#_x0000_t75" alt="\bar{x}" style="width: 8.25pt; height: 9pt; visibility: visible;"> <v:imagedata src="file:///C:%5CUsers%5CLiparulo%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_image001.png" o:title="bar{x}"> </v:imagedata></v:shape>+s.<o:p></o:p>
Copy and complete the table below for the four sites, by finding the percentage of values that fall within one, two, and three standard deviations of the mean for that data set.

Is it possible to calculate? I'm really quite desperate, and while I know its possible to do manually, there are a phenominal amount of values that need to be calculated. Let me know if you need any more information.

Thank you for your assistance.
<o:p></o:p>
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Say your data is in A1:A20. In A21 enter:

=AVERAGE(A1:A20)

and in A22 enter:

=STDEV(A1:A20)

Then your 3 percentages are given by these formulas:

=(COUNTIF(A1:A20,"<="&SUM(A21,A22))-COUNTIF(A1:A20,"<"&(A21-A22)))/COUNT(A1:A20)

=(COUNTIF(A1:A20,"<="&SUM(A21,A22*2))-COUNTIF(A1:A20,"<"&(A21-A22*2)))/COUNT(A1:A20)

=(COUNTIF(A1:A20,"<="&SUM(A21,A22*3))-COUNTIF(A1:A20,"<"&(A21-A22*3)))/COUNT(A1:A20)
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top