statistics with excel
DESCRIPTION
Statistics With Excel. Sam Gordji [email protected] Weir 107. Obtaining the Sum of Three Numbers. Enter 1,2, and 3 in columns A1,A2, and A3 Under Formula click the “More Functions” and choose Statistical From Statistical choose ”AVERAGE” - PowerPoint PPT PresentationTRANSCRIPT
![Page 2: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/2.jpg)
Obtaining the Sum of Three Numbers
• Enter 1,2, and 3 in columns A1,A2, and A3• Under Formula click the “More Functions” and
choose Statistical • From Statistical choose ”AVERAGE”• Enter the correct column, e.g.
AVERAGE(A1:A3), then click • The result for the mean, which Excel calls
AVERAGE, will appear
![Page 3: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/3.jpg)
To obtain the Variance of the Same Three Numbers, From “Statistical” Choose ”VARA” Enter 1,2, and 3 in the Small Window Below
and Click “OK”
![Page 4: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/4.jpg)
To obtain the Standard of Deviation for the Same Three Numbers From “Statistical” Choose ”STDEVA” Enter 1,2, and 3 in the Small Window
Below and Click “OK”
![Page 5: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/5.jpg)
To obtain Different Values for Error Function Choose Engineering Function, Then ERF, the Value of the
Error Function e.g. Between 0<E<100 is 1, and is Printed
Below
![Page 6: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/6.jpg)
To obtain Another Value for the Error Function Choose Engineering Function, then ERF, Choose the
Value of the Error Function Between 0<E<.7. The Result Is .677
![Page 7: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/7.jpg)
From the Math & Trig, the “Green Folder “ Calculate
• SIN of 1.6• Cos of 3.14158• PI• SQRT of 9• LOG10 of 100• SUM of 1, 2, 3• EXP of 1• LOG of 2
![Page 8: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/8.jpg)
“LOG” of 1000000 is 6
![Page 9: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/9.jpg)
Using Excel Formulas to Obtain Simple Statistics
• Enter 1,2, 3, 4, and 5 into column A1 to A5• Open Formulas• Enter “=“, click on the sum symbol, then
enter: (A1:A5)• The formula should look like: “=SUM(A1:A5)”• Click enter• This gives the sum of numbers 1,2,3,4, and 5
![Page 10: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/10.jpg)
Using Excel Formulas to Obtain Simple Statistics (Chi Squared)
• Use the arrow next to the AutoSum under formulas and calculate Sum, Average, Count Numbers and so on using the data that you have on columns A1 to A4
• Obtain the CHITEST for: 2 3 4 5 6 and 4 4 4 4 4 Using CHITEST Function
• First create 2 columns containing the above 2 vectors• Then Statistical->CHITEST, enter the Actual Range
and then the Expected Value
![Page 11: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/11.jpg)
Performing the FTEST
To the left is the answer for the FTEST
![Page 12: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/12.jpg)
Performing Covariance Analysis
5.2 to the left is the ans.
![Page 13: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/13.jpg)
Pearson Correlation
Pearson Corr. Is equal .997
![Page 14: Statistics With Excel](https://reader035.vdocuments.us/reader035/viewer/2022062305/56815a17550346895dc76172/html5/thumbnails/14.jpg)
Obtaining the Slope Between Two Columns
The slope is:
The slope is .382