# examine data to measure median, 25 and 75 percentile

Copper Contributor

# examine data to measure median, 25 and 75 percentile

Hi, we received data grouped by auction lot according to similar parameters. For example weight (kg) of the auction offering, by measure (micron) by auction price. Other parameters include hauture, SD (of micron) etc. Perhaps a multiple regression analysis would be of benefit. I'm trying to determine where our best prices occurred so we can aim to breed sheep with these parameters. How would I examine our results to this end?

# Re: examine data to measure median, 25 and 75 percentile

To examine the data and measure the median, 25th and 75th percentiles, you can use Excel's built-in functions. Here's how:

1. Open the Excel file with the data and select the column containing the auction prices.

2. Click on the "Formulas" tab at the top of the screen.

3. Click on "Insert Function" and search for the function "MEDIAN". Click "OK".

4. In the "Function Arguments" dialog box, select the range of cells containing the auction prices. Click "OK". This will calculate the median of the auction prices.

5. To calculate the 25th and 75th percentiles, you can use the "PERCENTILE" function. Repeat steps 3 and 4, but instead of selecting "MEDIAN", select "PERCENTILE". In the "Function Arguments" dialog box, select the range of cells containing the auction prices, and enter "25" or "75" for the second argument, depending on which percentile you want to calculate.

To determine where the best prices occurred, you can create a scatter plot of the data with auction price on the y-axis and the other parameters (e.g. weight, micron, hauture) on the x-axis. You can then visually examine the plot to see if there are any clear patterns or correlations between the parameters and auction price. If you want to perform a multiple regression analysis to quantify these relationships, you can use Excel's built-in regression analysis tool. Here's how:

1. Select the columns containing the parameters and auction prices.

2. Click on the "Data" tab at the top of the screen.

3. Click on "Data Analysis" in the Analysis group.

4. Select "Regression" and click "OK".

5. In the "Regression" dialog box, select the range of cells containing the parameters and auction prices. Make sure the "Labels" checkbox is checked if your data has column headers.

6. In the "Output Options" section, check the boxes for "Residuals" and "Standardized residuals" if you want to examine the model fit.

7. Click "OK" to run the regression analysis. The results will be displayed in a new sheet.

The regression analysis will provide you with coefficients for each parameter, indicating how much they contribute to the auction price. You can use these coefficients to identify which parameters are most important for maximizing the auction price, and use this information to breed sheep with these parameters.