![where do i find the phstat in excel where do i find the phstat in excel](https://media.cheggcdn.com/study/664/664810c3-e8c2-49cf-9a0e-9401ff7340f5/2682-14-61RP-i47.png)
Where do i find the phstat in excel archive#
in the PHStat zip archive that you download and expand to the folder of your choice. The macro-enabled workbook, PHStat, is one of several files.
Where do i find the phstat in excel software#
It is not intended to take the place of your Excel user’s manual, however it will introduce the Excel novice to the software and provide the basic tools necessary to analyze statistical data using Excel. PHStat takes the form of what Excel calls a macro-enabled workbook, a standard Excel file. To accomplish this goal, we follow a four-part process. What is the probability of finding exactly 9 cars coded vs 0 in this sample d. How many vs 0 would we expect to find in this sample c. Is this a valid binomial situation Are all the assumptions met b. For formulas to show results, select them, press F2, and then press Enter. First, we introduce the statistical procedures available in Excel. Use Excel/PHStat to get the binomial probabilities for the possible outcomes. MIN, MEDIAN, and MAX return the same value as QUARTILE when quart is equal to 0 (zero), 2, and 4, respectively.Ĭopy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. If quart 4, QUARTILE returns the #NUM! error value. If quart is not an integer, it is truncated. If array is empty, QUARTILE returns the #NUM! error value. The array or cell range of numeric values for which you want the quartile value. The QUARTILE function syntax has the following arguments:Īrray Required. The estimated regression equation is given by, MPG 12.7464 + 0.0391 Speed.
![where do i find the phstat in excel where do i find the phstat in excel](https://i.ytimg.com/vi/M8_gyhtB7v0/maxresdefault.jpg)
b) Apply simple regression analysis, and then interpret the meaning of the slope b1 in this problem. a) Set up a scatter diagram for speed and miles per gallon. Although this function is still available for backward compatibility, you should consider using the new functions from now on, because this function may not be available in future versions of Excel.įor more information about the new functions, see QUARTILE.EXC function and QUARTILE.INC function. The results are in the data set (SPEED.xls). Important: This function has been replaced with one or more new functions that may provide improved accuracy and whose names better reflect their usage. 1 A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed.