Homework Help is Here – Start Your Trial Now!
Engineering
Electrical Engineering
nstruction: Create a spreadshneet file named LastName_FirstName_PrelimExam_Part2 using Microsoft Excel or Google Sheets, then follow the instructions below. USE FUNCTIONS WHENEVER APPROPRIATE (No function used in your formula means INCORRECT). Problem: An experiment was conducted by some engineering students to study voltage, current, resistance, and power in a circuit that consists of a voltage source and a resistive load (a light bulb) connected in series. The output voltage of the voltage source, V, was varied over time and the current, I, through the circuit was measured, as shown in the table below. You have been asked to calculate some other quantities shown in the table. AE represents the energy dissipated in the resistor over a time interval of At = 0.50s, and AQ represents the charge flow through the resistor over a time interval of At = 0.50s. A в D E F G H 1 Point Elapsed Time (s) Power (W) P (A²) ΔΕ ) AQ (C) Voltage (V) 121.51 Current (A) 2 1 0.50 1.06 3 2 1.00 125.15 1.07 4 3 1.50 129.61 1.13 5 4 2.00 131.72 1.13 6 5 7 6 2.50 131.85 1.14 3.00 139.4 1.18 8 7 3.50 142.24 1.22 9 8 4.00 143.76 1.23 10 9 4.50 146.23 1.23 11 10 5.00 146.23 1.27 12 11 5.50 147.49 1.28 13 12 6.00 155.11 1.32 14 13 6.50 161.02 1.36 15 14 7.00 161.77 1.38 16 15 7.50 162.08 1.40 17 16 8.00 163.33 1.44 18 17 8.50 165.23 1.44 19 18 9.00 169.06 1.47 20 19 9.50 172.9 1.49 21 20 10.00 173.99 1.52 22 21 10.50 174.13 1.52

nstruction: Create a spreadshneet file named LastName_FirstName_PrelimExam_Part2 using Microsoft Excel or Google Sheets, then follow the instructions below. USE FUNCTIONS WHENEVER APPROPRIATE (No function used in your formula means INCORRECT). Problem: An experiment was conducted by some engineering students to study voltage, current, resistance, and power in a circuit that consists of a voltage source and a resistive load (a light bulb) connected in series. The output voltage of the voltage source, V, was varied over time and the current, I, through the circuit was measured, as shown in the table below. You have been asked to calculate some other quantities shown in the table. AE represents the energy dissipated in the resistor over a time interval of At = 0.50s, and AQ represents the charge flow through the resistor over a time interval of At = 0.50s. A в D E F G H 1 Point Elapsed Time (s) Power (W) P (A²) ΔΕ ) AQ (C) Voltage (V) 121.51 Current (A) 2 1 0.50 1.06 3 2 1.00 125.15 1.07 4 3 1.50 129.61 1.13 5 4 2.00 131.72 1.13 6 5 7 6 2.50 131.85 1.14 3.00 139.4 1.18 8 7 3.50 142.24 1.22 9 8 4.00 143.76 1.23 10 9 4.50 146.23 1.23 11 10 5.00 146.23 1.27 12 11 5.50 147.49 1.28 13 12 6.00 155.11 1.32 14 13 6.50 161.02 1.36 15 14 7.00 161.77 1.38 16 15 7.50 162.08 1.40 17 16 8.00 163.33 1.44 18 17 8.50 165.23 1.44 19 18 9.00 169.06 1.47 20 19 9.50 172.9 1.49 21 20 10.00 173.99 1.52 22 21 10.50 174.13 1.52

Introductory Circuit Analysis (13th Edition)
Introductory Circuit Analysis (13th Edition)
13th Edition
ISBN:9780133923605
Author:Robert L. Boylestad
Publisher:Robert L. Boylestad
Chapter1: Introduction
Section: Chapter Questions
Problem 1P: Visit your local library (at school or home) and describe the extent to which it provides literature...
See similar textbooks
icon
Related questions
Question

what functions of formula should I use for me to get the value of the following empty rows and columns

Instruction: Create a spreadsheet file named LastName_FirstName_PrelimExam_Part2 using Microsoft Excel or Google Sheets, then follow the instructions below. USE FUNCTIONS WHENEVER APPROPRIATE (No function used in your formula means INCORRECT). Problem: An experiment was conducted by some engineering students to study voltage, current, resistance, and power in a circuit that consists of a voltage source and a resistive load (a light bulb) connected in series. The output voltage of the voltage source, V, was varied over time and the current, I, through the circuit was measured, as shown in the table below. You have been asked to calculate some other quantities shown in the table. AE represents the energy dissipated in the resistor over a time interval of At = 0.50s, and AQ represents the charge flow through the resistor over a time interval of At = 0.50s. A в D F G H 1 Point ΔQ (C) Power (W) P (A²) Elapsed Time (s) Voltage (V) Current ΔΕ ) (A) 2 1 3 2 4 3 0.50 121.51 1.06 1.00 125.15 1.07 1.50 129.61 1.13 5 4 2.00 131.72 1.13 6 5 7 2.50 131.85 1.14 6 3.00 139.4 1.18 8 7 3.50 142.24 1.22 9 8 4.00 143.76 1.23 10 9 4.50 146.23 1.23 11 10 12 11 5.00 146.23 1.27 5.50 147.49 1.28 13 12 6.00 155.11 1.32 14 13 6.50 161.02 1.36 15 14 7.00 161.77 1.38 16 15 7.50 162.08 1.40 17 16 8.00 163.33 1.44 18 17 19 18 20 19 21 20 8.50 165.23 1.44 9.00 169.06 1.47 9.50 172.9 1.49 10.00 173.99 1.52 22 21 10.50 174.13 1.52
Transcribed Image Text:Instruction: Create a spreadsheet file named LastName_FirstName_PrelimExam_Part2 using Microsoft Excel or Google Sheets, then follow the instructions below. USE FUNCTIONS WHENEVER APPROPRIATE (No function used in your formula means INCORRECT). Problem: An experiment was conducted by some engineering students to study voltage, current, resistance, and power in a circuit that consists of a voltage source and a resistive load (a light bulb) connected in series. The output voltage of the voltage source, V, was varied over time and the current, I, through the circuit was measured, as shown in the table below. You have been asked to calculate some other quantities shown in the table. AE represents the energy dissipated in the resistor over a time interval of At = 0.50s, and AQ represents the charge flow through the resistor over a time interval of At = 0.50s. A в D F G H 1 Point ΔQ (C) Power (W) P (A²) Elapsed Time (s) Voltage (V) Current ΔΕ ) (A) 2 1 3 2 4 3 0.50 121.51 1.06 1.00 125.15 1.07 1.50 129.61 1.13 5 4 2.00 131.72 1.13 6 5 7 2.50 131.85 1.14 6 3.00 139.4 1.18 8 7 3.50 142.24 1.22 9 8 4.00 143.76 1.23 10 9 4.50 146.23 1.23 11 10 12 11 5.00 146.23 1.27 5.50 147.49 1.28 13 12 6.00 155.11 1.32 14 13 6.50 161.02 1.36 15 14 7.00 161.77 1.38 16 15 7.50 162.08 1.40 17 16 8.00 163.33 1.44 18 17 19 18 20 19 21 20 8.50 165.23 1.44 9.00 169.06 1.47 9.50 172.9 1.49 10.00 173.99 1.52 22 21 10.50 174.13 1.52
23 22 11.00 174.32 1.56 24 23 11.50 174.92 1.57 Symbols • AE = energy dissipated in At • AQ = total charge in At • V = voltage • P= power • = current • J = Joule • C = Coulomb At = 0.5s = time interval Formulas • P= (1)(V) = AE/At • V = AE/AQ • I = AQ/At 1. Enter the data above into an Excel spreadsheet. 2. Populate the remaining four columns by calculating AE, AQ, W and Pusing the formula given. 3. Format the cells to display 2 decimal places. Find the total energy consumption and the total charge consumption over 11.5 seconds. Display the results in a new and appropriately labeled row at the bottom of the table (row 25).
Transcribed Image Text:23 22 11.00 174.32 1.56 24 23 11.50 174.92 1.57 Symbols • AE = energy dissipated in At • AQ = total charge in At • V = voltage • P= power • = current • J = Joule • C = Coulomb At = 0.5s = time interval Formulas • P= (1)(V) = AE/At • V = AE/AQ • I = AQ/At 1. Enter the data above into an Excel spreadsheet. 2. Populate the remaining four columns by calculating AE, AQ, W and Pusing the formula given. 3. Format the cells to display 2 decimal places. Find the total energy consumption and the total charge consumption over 11.5 seconds. Display the results in a new and appropriately labeled row at the bottom of the table (row 25).
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Flyback and Push-Pull Converter
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, electrical-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Introductory Circuit Analysis (13th Edition)
Introductory Circuit Analysis (13th Edition)
Electrical Engineering
ISBN:
9780133923605
Author:
Robert L. Boylestad
Publisher:
PEARSON
Delmar's Standard Textbook Of Electricity
Delmar's Standard Textbook Of Electricity
Electrical Engineering
ISBN:
9781337900348
Author:
Stephen L. Herman
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Electrical Engineering
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
Fundamentals of Electric Circuits
Fundamentals of Electric Circuits
Electrical Engineering
ISBN:
9780078028229
Author:
Charles K Alexander, Matthew Sadiku
Publisher:
McGraw-Hill Education
Electric Circuits. (11th Edition)
Electric Circuits. (11th Edition)
Electrical Engineering
ISBN:
9780134746968
Author:
James W. Nilsson, Susan Riedel
Publisher:
PEARSON
Engineering Electromagnetics
Engineering Electromagnetics
Electrical Engineering
ISBN:
9780078028151
Author:
Hayt, William H. (william Hart), Jr, BUCK, John A.
Publisher:
Mcgraw-hill Education,
SEE MORE TEXTBOOKS