The equation for the Gaussian curve in Figure 4 - 1is

$\mathbf{y}\mathbf{=}\frac{\mathbf{(}\mathbf{total}\mathbf{}\mathbf{bulbs}\mathbf{)}\mathbf{(}\mathbf{hours}\mathbf{}\mathbf{per}\mathbf{}\mathbf{bar}\mathbf{)}}{\mathbf{s}\sqrt{\mathbf{2}\mathbf{\pi }}}{\mathbf{e}}^{\mathbf{-}{\mathbf{(}\mathbf{x}\mathbf{-}\overrightarrow{\mathbf{x}}\mathbf{)}}^{\mathbf{2}}\mathbf{/}\mathbf{2}{\mathbf{s}}^{\mathbf{2}}}$

where $\overline{\mathbf{x}}$ is the mean value $(845.2h)$ is the standard deviation $(94.2h)$ , total bulbs = 4768, and hours per bar ( = 20) is the width of each bar in Figure 4 - 1. Set up a spreadsheet like the one with this problem to calculate the coordinates of the Gaussian curve in Figure 4 - 1 from 500to 1200hin 25 - hintervals. Note the heavy use of parentheses in the formula at the bottom of the spreadsheet to force the computer to do the arithmetic as intended. Use Excel to graph your results.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!