refreshing excel skills lab

.pdf

School

Georgia State University *

*We aren’t endorsed by this school

Course

1112

Subject

Electrical Engineering

Date

Dec 6, 2023

Type

pdf

Pages

Uploaded by PresidentDiscovery12628

~freshing Excel Skills @; Date In thi s Exc el refresher experiment we will me as ure volt a ge s a nd lengths a nd ana ly ze thi s data us ing Exc el to test a hypothe si s. You will l ea rn more about vo lt a ge s a nd re si stan ces later in th e se m es ter. The experiment Th e figure below shows a circ ui t Involving t wo re si sto rs a nd a power supply. Th e power s upply provid es a volta ge around 5 volts (V) a cro ss it s terminals. In this circuit th at volt age is sha red ac ross the tw o resistors in series, one fixed a nd the oth er variable. Resistors provide resistance to electric current {n a circuit. Resistance is measured in ohm s (0). The resistance of the fixed res istor is 10 o hms. Th e resista nce of the variable resistor (call ed a rheostat) varies from zero to 22 ohm s a nd is ch a nged by moving the slider along the ax is of th e rheostat. Vari a ble resistor (R,) Fixed resistor (R z) Vz _,,,,,,..,, Voltmeter V1 Power supply voltage= Vo R1- Resistan c, : ,,, , n 1 hl e resistor R2 - Resistan ce , 11 ' , · ,. - csistor Vi - Volt a ge ac rn ,s ,' V2 - Voltage across k It can be shown that V 1 L -oc-- Vz Lmax Hypothesis: The graph of vs . _L_ w ill b, " V2 Lm ax straight line with slop e 2.2 an d intercept zero. We will use a voltmeter to measure the voltage across the variable resistor. Your TA will set up an example circuit to help you set the circuit up fo~ yourself. Once your circuit is set up you will then need to make measurements as described below to collect your data. 1. Move the slider in the variable resistor and see if the voltage displa yed in the voltmeter changes. If it does not, please talk to your TA before continuing further. z. Notice th at as you move th e sl ider to the other end of the resistor, th e voltage a cro ss the variable resistor increases. Now you are re a dy to make measurements of voltages for d iffe rent lengths. 3. Record the dista nce from point A to the pointer of th e slider as shown in th e fi gur e. Dete rmine th e length to the closest millim eter, for example, length= 5.7 cm. The mi ll imeter digit is th e sma ll es t significant digit in this m ea sureme nt. 4. Measure the corresponding volta ge using the voltmeter to thr ee decimal pl aces. 1 j

5. Continue taking m eas ur em e nts of length a nd vo lt a ge to cove r almo st th e co mplete len g th ufthe slider ma king at least S me asurements. Meas ur eme nt s do n · t n eed to be e venl y sp <1ced. On e of your me as ur eme nts sh ould be for the maximum le ngth available. Tr ans fer yo ur dJta from the table ab ove to an E xce l spr ea ds heet. Mak e s ure you have col umn head ings as sh ow n in th e table below . 6. Next add new columns in your Excel spreadsheet and give them column headin gs as in the following table. Use the formula entry and fill down command to calculate the entries fo r eac h of the cells in these three columns . Do not use calculators or type the values in individu a ll y. Ask your TA for help if you are unsure how to use formula entry or to propagate t he fo rmula using fill down . $)-=- ~ 1 \Y1 7. Plot V1/Vz vs. L/lma . ,. Add a linear tre nd line and display the equation on chart (with appro µ 1 •. t • decimal places). Label the axes (including units?) and title the graph. Open a Word doc11111c111 , put your names on it and then copy and paste the graph into the document You will print thL ' Word document and attach it to this report to hand in at the end of the experiment. 8. What is the slope of the trend line? Slope= _ \u, .... ,(a_ l .:..__ <.J _,__ ___ _ 9. What is the intercept of the trend line? Intercept= -' O ~, Z.--=-¥)0"---L _____ _ 10. Does this experiment and analysis support or refute the earlier hypothesis for th e slope and intercept? Explain how you decide . 7'~\~ ~(X'N'VhU\\ ~~ ~\"'\~ o\\\e ~,~ ~k,Notef\ 'ffi°W-<._ . \ \ \":) C\t\X,<f() zem ~ ~~ °'-itWVW 1.\- C~Jd ~\A-. \~":)Y\t)\ 0K ~, \ C.lA~ $(__ 0\ 1 ~Y).\,\ ~~ ru11~ c \\ ~\\ t).Ar) c,.__s\""\ \c,v-\ VO~ Instructions on how to submit the graph • Open a Word document and typ e th e names of a ll present group members. • Copy and paste into the document yo ur gr aph w ith trendline and l abe led axes from Que s ti on 7. • Print the Word document a nd att ac h it to thi s lab write-up. 2

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version