Prepare an EXCEL spreadsheet as shown in the table below for one cycle of 60 Hz ac in the increments of 15 With 0, plot the voltage, current, and power versus t using the CHART function in EXCEL Find the average values of columns 2 through 5 Then, verify that (a) The square root of Avg4 is equal to...

The Answer is in the image, click to view ...

Prepare an EXCEL spreadsheet as shown in the table below for one cycle of 60-Hz ac in

Question:

Prepare an EXCEL spreadsheet as shown in the table below for one cycle of 60-Hz ac in the increments of 15°. With θ = 0°, plot the voltage, current, and power versus ωt using the CHART function in EXCEL. Find the average values of columns 2 through 5. Then, verify that

(a) The square root of Avg4 is equal to the rms value I_peak/√2 and

(b) Average power Avg5 is equal to V_rms I_rms cos θ. Make sure to convert ωt degrees into radians for the EXCEL computations if necessary. Make and plot the second spreadsheet with θ = 30° and the third sheet with θ = 90°. Examining your numerical answers and the charts, draw your conclusions as to the effect of lag angle θ on the average power.

wt 0 15 360 Avg v=100 sin oot i=150 sin(@t-8) Avg2 Avg3 i Avg4 v* i Avg5