Beta of a BJT

Purpose

The purpose of this lab is to figure our the beta(gain) of a BJT by finding the linear relationship between Ie and Ib. For a NPN typed BJT, Ie = (1+beta)*Ib

The built circuit looks like as following

Figure 1.

Measured V         Rb(Theoretical)         Rb(actual)            Ib                   Ie

6.05 V                       530 k ohm           529 k ohm          0.011 mA      1.36 mA

6.05 V                       265 k ohm           263 k ohm          0.021 mA      2.81 mA

6.05 V                       176 k ohm           176.6 k ohm       0.033 mA      4.18 mA

6.05 V                       132 k ohm           132.5 k ohm       0.046 mA      5.56 mA

6.05 V                       106 k ohm           106.4 k ohm       0.058 mA      6.98 mA

Using EXCEL to graph Ie v.s Ib 

Therefore, 1+beta=117.3 ========> beta=116.3