n the spreadsheet "The Diode - Student Data" click the tab at the bottom of the spreadsheet labeled "Monte Carlo V_th". Enter into the row labeled "Best" your values of the slope and intercept from the fit using LINEST(). Enter into the row labeled "Uncertainty" your values of the uncertainties of slope and intercept. Calculate the best value of using the function =AVERAGE() in the spreadsheet. Calculate the uncertainty of using the function =STDEV() in the spreadsheet. Record the best +/- uncertainty of in the table below: Threshold Voltage (V) +/- Comparing Two Values of Threshold Voltage with Student's t-Test Now that you have a value and uncertainty of the diode's threshold voltage, is it what you expected it to be? How do you compare your results with the expected values? In order to compare two values and answer the question are they the same or different, you will need to do a Student t-Test. A Student's t-Test determines whether the difference between two values is due to expected random uncertainty of the values or a significant difference between. Let's compare your measured value of to the expected value of 0.66 V. First you need to calculate a t-score: Click