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" oreferrelative="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> <vath 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></vath></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" oreferrelative="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> <vath 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></vath></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="]±[/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></o>
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></o>
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" oreferrelative="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> <vath 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></vath></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" oreferrelative="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> <vath 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></vath></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="]±[/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></o>
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></o>