<p>This ends up being a bit of a mess. One should run a <a href="https://en.wikipedia.org/wiki/Generalized_linear_model" rel="nofollow">GLM with probit or logit link</a>.  The reason for this is that the regression is bounded, and we would not want your estimates to ignore the bounds and suggest grades of 130% or -20%. Such estimates can and likely will occur with OLS. <a href="http://www.ats.ucla.edu/stat/stata/faq/proportion.htm" rel="nofollow">See Stata Journal's post on this subject.</a>, or <a href="http://faculty.smu.edu/millimet/classes/eco6375/papers/papke%20wooldridge%201996.pdf" rel="nofollow">here</a>.  </p>

<p>Usually, these probit/logit regressions are used for binary data, consisting of 0 and 1. However, they will function well here, where the grade is the probability of getting any one question right.</p>

<p>The intercept has an analogue in these estimations, still. It is a constant term that will undergo a transformation depending on your choice of probit or logit.  I believe there are other link functions available, but they are not particularly common in economics literature.</p>

<p>Given:
$Y=\beta_0+x'\beta_{1..n}+\epsilon$ is your investigative target where </p>

<p>$0&lt;Y&lt;1$, $Y=grade,x=[gender,race,...]$</p>

<p>Assuming $\epsilon$ is logistically distributed, Logit: $\frac {1}{1+e^{-\beta_0}}$ </p>

<p>Assuming $\epsilon$  is normally distributed, Probit: $\Phi(\beta_0)$</p>

<p>Of course it is possible your distribution is none of these, but these are considered standard.</p>

<p>It is also the case that OLS is unbiased in estimating an intercept for this type of data, but it may suggest impossible grades (for example, -0.2 or 1.3 as an intercept).  The reason this is impossible is because one cannot get a -0.2 or a -1.3 as a percentile grade.</p>

CC BY-SA 3.0
2015-11-03T00:40:40.523Z
I would have suggested probit or logit if ethnicity was the only dependent variable, but I think OP suggested that he/she had more data (*"by ethnicity and other indicators"*) but I could be misreading.
Kitsune Cavalry
CC BY-SA 3.0
2015-11-03T01:16:09.193Z
I don't believe the shape of the X variables impacts the appropriate choice of regression. I'm fairly certain that it will still have the normal properties (perhaps the standard errors on the coefficients are less than ideal)?
RegressForward
CC BY-SA 3.0
2015-11-03T13:28:27.577Z
the main problem is that I only have the grades to work on, I am new to STATS and all the information I have so far has been from videos online. I understand how to make the dummy variable work on various stages but I don't know where to start with knowing just the grades. Thank you again
anonymous1
CC BY-SA 3.0
2015-11-03T23:44:04.643Z
deleted my comment. agree with what you've got now.
Jamzy
CC BY-SA 3.0
2015-11-02T20:24:49.447Z
2015-11-03T23:25:28.817Z
2015-11-03T23:25:28.817Z
RegressForward
<p>As Jamzy noted, run an OLS regression on grades against whatever variables you have.</p>

<p>$$\text{grades} = \beta_0 + \beta_1 x_1 + \cdots + \beta_i \ \text{race} + \cdots$$</p>

<p>$$\text{race} =\begin{array}{cc}
  \Bigg\{ &amp; 
    \begin{array}{cc}
      0 &amp; mixed \\
      1 &amp; Chinese \\
    \end{array}
\end{array}$$</p>

<p>or vice versa with the 0 and 1. $\beta_0$ will be your intercept that you are looking for. If it ends up negative, try taking the log of both sides and see if a linear regression still has a good fit for you there.</p>

CC BY-SA 3.0
2015-11-02T04:24:34.507Z
2015-11-02T04:24:34.507Z
Kitsune Cavalry
<p>How do I find an intercept on a percentage data? My data has percentage of grades ( I have converted to numbers where $A^*=8, A=7,B=6...U=0$) by ethnicity and other indicators which I want to test for using dummy variables. For example 90.3% of Chinese students got $A^*-C$ grade, Mixed race students got 87.3% etc. How do I interpret this to get an intercept? I have chosen the median 32.5 as the grades are 5 $A^*$ to $C$ (between $A^*(8\cdot5=40)$ and $C( 5\cdot5=25)$. Is the use of median in this case sensible? </p>

<p>My equation is going to be </p>

<p>$y =b_0 +b_1 +b_2+b_3+b_4+b_5+b_6+u$</p>

<p>where $y$ is the grade, $b_0$ is the median ( constant), $b_1$ is the free school meal, $b_2$ is Chinese, $b_3$ is Black, $b_4$ is Asian, $b_5$ is male,    $b_6$ is female, and $u$ is the error term.
White is the default.</p>

<p>Therefore if a Chinese male pupil does not get free school meals(proxy for poverty)it is $b_0 + b_2 + b_5$.</p>

<p>My question is as above, does my use of median make any sense and secondly since I already know that Chinese pupils perform better than the rest of the group do I need to use the percentage difference or use the dummy binary variables.</p>

<p>I want to simply find out the effect of poverty and race on the pupils expected grades. I do not have access to individual grades or panel data for income etc hence why I want to use the free school meal.</p>

<p>Thanks again for your answers.</p>

<p>Please see image below.<br>
<a href="https://i.sstatic.net/ctS1k.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/ctS1k.png" alt="GCSE Result by Ethnicity"></a></p>

CC BY-SA 3.0
2015-11-02T01:45:15.763Z
You will need to run an OLS regression. One of the coefficients reported will be the intercept.
Jamzy
CC BY-SA 3.0
2015-11-03T17:48:06.577Z
Minor note: I'd reckon including one gender dummy would be enough as they seem mutually exclusive.
horseoftheyear
CC BY-SA 3.0
2015-11-03T21:42:53.680Z
Thanks, I however only have one variable (grades) y and don't know how to run an OLS from that to get y^
anonymous1
<microeconomics><econometrics><mathematical-economics><labor-economics><statistics>
Finding an intercept on percentage based data and using dummy variables
anonymous1
# Finding an intercept on percentage based data and using dummy variables

(Asked by: username_0 on 2015-11-01)

How do I find an intercept on a percentage data? My data has percentage of grades ( I have converted to numbers where $A^\*=8, A=7,B=6...U=0$) by ethnicity and other indicators which I want to test for using dummy variables. For example 90.3% of Chinese students got $A^\*-C$ grade, Mixed race students got 87.3% etc. How do I interpret this to get an intercept? I have chosen the median 32.5 as the grades are 5 $A^\*$ to $C$ (between $A^\*(8\cdot5=40)$ and $C( 5\cdot5=25)$. Is the use of median in this case sensible?

My equation is going to be

$y =b\_0 +b\_1 +b\_2+b\_3+b\_4+b\_5+b\_6+u$

where $y$ is the grade, $b\_0$ is the median ( constant), $b\_1$ is the free school meal, $b\_2$ is Chinese, $b\_3$ is Black, $b\_4$ is Asian, $b\_5$ is male, $b\_6$ is female, and $u$ is the error term.
White is the default.

Therefore if a Chinese male pupil does not get free school meals(proxy for poverty)it is $b\_0 + b\_2 + b\_5$.

My question is as above, does my use of median make any sense and secondly since I already know that Chinese pupils perform better than the rest of the group do I need to use the percentage difference or use the dummy binary variables.

I want to simply find out the effect of poverty and race on the pupils expected grades. I do not have access to individual grades or panel data for income etc hence why I want to use the free school meal.

Thanks again for your answers.

Please see image below.  
[![GCSE Result by Ethnicity](https://i.sstatic.net/ctS1k.png)](https://i.sstatic.net/ctS1k.png)

**Tags:** microeconomics, econometrics, mathematical-economics, labor-economics, statistics
> **Comments:**
> **username_1**: You will need to run an OLS regression. One of the coefficients reported will be the intercept.  
> **username_2**: Minor note: I'd reckon including one gender dummy would be enough as they seem mutually exclusive.  
> **username_0**: Thanks, I however only have one variable (grades) y and don't know how to run an OLS from that to get y^  

---

## 2 answers

### Answer by username_3 on 2015-11-02. Score: 2

This ends up being a bit of a mess. One should run a [GLM with probit or logit link](https://en.wikipedia.org/wiki/Generalized_linear_model). The reason for this is that the regression is bounded, and we would not want your estimates to ignore the bounds and suggest grades of 130% or -20%. Such estimates can and likely will occur with OLS. [See Stata Journal's post on this subject.](http://www.ats.ucla.edu/stat/stata/faq/proportion.htm), or [here](http://faculty.smu.edu/millimet/classes/eco6375/papers/papke%20wooldridge%201996.pdf).

Usually, these probit/logit regressions are used for binary data, consisting of 0 and 1. However, they will function well here, where the grade is the probability of getting any one question right.

The intercept has an analogue in these estimations, still. It is a constant term that will undergo a transformation depending on your choice of probit or logit. I believe there are other link functions available, but they are not particularly common in economics literature.

Given:
$Y=\beta\_0+x'\beta\_{1..n}+\epsilon$ is your investigative target where

$0

Assuming $\epsilon$ is logistically distributed, Logit: $\frac {1}{1+e^{-\beta\_0}}$

Assuming $\epsilon$ is normally distributed, Probit: $\Phi(\beta\_0)$

Of course it is possible your distribution is none of these, but these are considered standard.

It is also the case that OLS is unbiased in estimating an intercept for this type of data, but it may suggest impossible grades (for example, -0.2 or 1.3 as an intercept). The reason this is impossible is because one cannot get a -0.2 or a -1.3 as a percentile grade.

> **Comments:**
> **username_4**: I would have suggested probit or logit if ethnicity was the only dependent variable, but I think OP suggested that he/she had more data (*"by ethnicity and other indicators"*) but I could be misreading.  
> **username_3**: I don't believe the shape of the X variables impacts the appropriate choice of regression. I'm fairly certain that it will still have the normal properties (perhaps the standard errors on the coefficients are less than ideal)?  
> **username_0**: the main problem is that I only have the grades to work on, I am new to STATS and all the information I have so far has been from videos online. I understand how to make the dummy variable work on various stages but I don't know where to start with knowing just the grades. Thank you again  
> **username_1**: deleted my comment. agree with what you've got now.  

---

### Answer by username_4 on 2015-11-02. Score: 2

As Jamzy noted, run an OLS regression on grades against whatever variables you have.

$$\text{grades} = \beta\_0 + \beta\_1 x\_1 + \cdots + \beta\_i \ \text{race} + \cdots$$

$$\text{race} =\begin{array}{cc}
\Bigg\{ &
\begin{array}{cc}
0 & mixed \\
1 & Chinese \\
\end{array}
\end{array}$$

or vice versa with the 0 and 1. $\beta\_0$ will be your intercept that you are looking for. If it ends up negative, try taking the log of both sides and see if a linear regression still has a good fit for you there.


---

