HELP!!! needed on excel

t3tral1nk1 · Apr 22, 2009

hi umm im new to this spreadsheet an all and i was wondering if any 1 can help me out here with this question.

<style>  </style><link rel="File-List" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml">I need to calculate the mean and the standard deviation of the data (based on the frequency table)

This is the data (<link rel="File-List" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style>Descriptive Statistics)

<link rel="File-List" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> <table class="MsoNormalTable" style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 18.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 18.2pt;" valign="top" width="113">

124<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 18.2pt;" valign="top" width="110">

153<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 18.2pt;" valign="top" width="115">

157<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 18.2pt;" valign="top" width="108">

160 <o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 18.2pt;" valign="top" width="109">

167<o

></o

>

</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 17.2pt;" valign="top" width="113">

141<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 17.2pt;" valign="top" width="110">

153<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 17.2pt;" valign="top" width="115">

157<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 17.2pt;" valign="top" width="108">

161<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 17.2pt;" valign="top" width="109">

170<o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

143<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

153 <o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

157<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

162<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

172<o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

144<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

155<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

158<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

164<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

172 <o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

146<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

156<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

158<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

164<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

173<o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

147<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

156<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

159<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

164 <o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

175<o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

147<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

156<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

159<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

165<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

176<o

></o

>

</td> </tr> <tr style="height: 16.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.7pt;" valign="top" width="113">

149<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.7pt;" valign="top" width="110">

156<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.7pt;" valign="top" width="115">

159<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.7pt;" valign="top" width="108">

167 <o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 16.7pt;" valign="top" width="109">

177<o

></o

>

</td> </tr> <tr style="height: 19.7pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 84.55pt; height: 19.7pt;" valign="top" width="113">

151<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 82.55pt; height: 19.7pt;" valign="top" width="110">

156<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.2pt; height: 19.7pt;" valign="top" width="115">

159 <o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 80.95pt; height: 19.7pt;" valign="top" width="108">

167<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 81.75pt; height: 19.7pt;" valign="top" width="109">

183<o

></o

>

</td> </tr> <tr style="height: 16.2pt;"> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 84.55pt; height: 16.2pt;" valign="top" width="113">

152<o

></o

>

</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 82.55pt; height: 16.2pt;" valign="top" width="110">

157<o

></o

>

</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 86.2pt; height: 16.2pt;" valign="top" width="115">

160<o

></o

>

</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 80.95pt; height: 16.2pt;" valign="top" width="108">

167<o

></o

>

</td> <td style="border: 1pt solid windowtext; padding: 0cm 9pt; width: 81.75pt; height: 16.2pt;" valign="top" width="109">

184<o

></o

>

</td> </tr> </tbody></table>

This is my freqencey table..

<link rel="File-List" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="themeData" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5CMuhammad%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><style>  </style> <table class="MsoNormalTable" style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 39.95pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 39.95pt;" valign="top" width="115">

Class Interval <o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 39.95pt;" valign="top" width="115">

X <o></o>

Class Mark<o

></o

>

</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 39.95pt;" valign="top" width="115">

F<o></o>

Frequency <o

></o

>

</td> <td style="border-style: solid none none; border-color: windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 0cm 9pt; width: 77.25pt; height: 39.95pt;" valign="top" width="103">

f.x<o

></o

>

</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 39.95pt;" valign="top" width="128">

f.x<sup>2</sup><o

></o

>

</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 124<130<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 127<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 1<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 127<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 16129<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 130<136<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 133<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 0<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 0<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 0<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 136<142<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 139<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 1<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 139<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 19321<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 142<148<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 145<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 5<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 725<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 105125<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 148<154<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 151<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 6<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 906<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 136806<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 154<160<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 157<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 16<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 2512<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 394384<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 160<166<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 163<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 8<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 1304<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 212552<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 166<172<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 169<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 5<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 845<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 142805<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 172<178<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 175<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 6<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 1050<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 183750<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 178<184<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 181<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 1<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 181<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 32761<o

></o

>
</td> </tr> <tr style="height: 17.2pt;"> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.5pt; height: 17.2pt;" valign="top" width="115"> 184<190<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 187<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 86.6pt; height: 17.2pt;" valign="top" width="115"> 1<o

></o

>
</td> <td style="border-style: solid none none solid; border-color: windowtext -moz-use-text-color -moz-use-text-color windowtext; border-width: 1pt medium medium 1pt; padding: 0cm 9pt; width: 77.25pt; height: 17.2pt;" valign="top" width="103"> 187<o

></o

>
</td> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 9pt; width: 96.35pt; height: 17.2pt;" valign="top" width="128"> 34969<o

></o

>
</td> </tr> <tr style="height: 24.45pt;"> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 86.5pt; height: 24.45pt;" valign="top" width="115"> <o

> </o

>
</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 86.6pt; height: 24.45pt;" valign="top" width="115"> Totals<o

></o

>
</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 86.6pt; height: 24.45pt;" valign="top" width="115"> åf = 50<o

></o

>
</td> <td style="border-style: solid none solid solid; border-color: windowtext -moz-use-text-color windowtext windowtext; border-width: 1pt medium 1pt 1pt; padding: 0cm 9pt; width: 77.25pt; height: 24.45pt;" valign="top" width="103"> åfx = 7976<o

></o

>
</td> <td style="border: 1pt solid windowtext; padding: 0cm 9pt; width: 96.35pt; height: 24.45pt;" valign="top" width="128"> åfx<sup>2</sup>= 1278602<o

></o

>
</td> </tr> </tbody></table>

so i need the formula to do standard-D and mean also i need to[FONT=&quot] provide a suitable chart for representing the Class Marks and the associated frequencies.

i would be greatfulll for any advice...or maybe if some can show me how to do it????/ that would be even better...

p.s this does has to be done on excel!!!!!

thx guyz
[/FONT]

smiths87 · Apr 22, 2009

You can get standard deviation using the STDEV function.

t3tral1nk1 · Apr 22, 2009

smiths87 said:
You can get standard deviation using the STDEV function.

yes i know,,,but i need to know the formula

jolivanes · Apr 22, 2009

Does this site help at all?

http://en.wikipedia.org/wiki/Standard_deviation

HTH
John

t3tral1nk1 · Apr 22, 2009

jolivanes said:
Does this site help at all?

http://en.wikipedia.org/wiki/Standard_deviation

HTH
John

dude i know how to do the standard deviation...all im asking is how i can transfer the freqencey table on excel with formulas...

....

VoG · Apr 22, 2009

t3tral1nk1 said:
dude i know how to do the standard deviation...all im asking is how i can transfer the freqencey table on excel with formulas...

....

What do you mean exactly?

t3tral1nk1 · Apr 22, 2009

VoG said:
What do you mean exactly?

i need to calculate the mean and the standard deviation of the data presented, which both should be based on the frequency table i have produced and the standard formulae.[FONT=&quot] [/FONT]

VoG · Apr 22, 2009

Why can't you do this based upon the raw data? Is this a homework assignment?

t3tral1nk1 · Apr 22, 2009

VoG said:
Why can't you do this based upon the raw data? Is this a homework assignment?

lol....it is kinda a assigmeent but yea i can do that based on the descriptive statistic ( raw data ) but i need formula to do that....thats what im stuck on..

Andrew Fergus · Apr 22, 2009

Hi

You can get this with a single formula (without using STDEV) but I'm guessing you will need to show your workings if you want to understand the mechanics.

Arrange your data so that all of the raw data is in column A. Next calculate the count of the values in column A using the COUNT function - this provides the value 'n' per the Wikipedia article. Then get an average of the values in column A using the AVERAGE function - this provides the mean value.

In column B enter the formula to subtract the mean value from the raw data for every row of data - this is the deviation from the mean. In column C enter a formula to multiply the value in column B by itself, again for every row of data. The reason for squaring the value is to express each deviation as a positive number - if you sum positive and negative numbers you lose the ability to measure the absolute variation from the mean.

Then use a formula to total the value in column C, divide that value by the value (n-1) and take the square root of the answer. This provides the same answer as the STDEV function.

Andrew

HELP!!! needed on excel

t3tral1nk1

New Member

Excel Facts

smiths87

Board Regular

t3tral1nk1

New Member

jolivanes

Well-known Member

t3tral1nk1

New Member

VoG

Legend

t3tral1nk1

New Member

VoG

Legend

t3tral1nk1

New Member

Andrew Fergus

MrExcel MVP

Similar threads

Forum statistics

Share this page

HELP!!! needed on excel

New Member

Excel Facts

Board Regular

New Member

Well-known Member

New Member

Legend

New Member

Legend

New Member

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock