Concept explainers
Download the weekly retail gasoline and diesel prices Excel workbook Gasoline.xlsx associated with this review question and place it in your main MATLAB Current Directory. This data set is based on the data set available from the U.S. Energy Information Administration: http://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_w.htm. WARNING: Your system MAY import the first column (dates) as numeric date codes instead of ignoring them as text, so watch out.
a. Calculate the average, minimum, and maximum retail fuel prices for each of the different types of fuel (regular, midgrade, premium, diesel) over the duration of the entire sample set. Your output should work in such a way that if the original Excel file were modified to include more weeks (rows), you would not need to change your MATLAB code. Your output should appear similar to the following format, where the blanks are replaced by the actual calculated values:
Your code should calculate the values shown in the output—you should not hard-code the values in the output. Each value you display should appear with two decimal values. You may use any built-in MATLAB function, including functions that find the minimum, maximum, or average values.
b. We have decided that we want to modify our previous analysis in part (a) to export the computed max, min, and average values to a new Microsoft Excel workbook. The data itself should be exported to a sheet named Fuel Price Analysis. Your data should appear similar to the worksheet that follows. Much like part (a), your code should be written in such a way that if the original Excel file were modified to include more weeks (rows), you would not need to change your MATLAB code.
Want to see the full answer?
Check out a sample textbook solutionChapter 17 Solutions
Thinking Like an Engineer: An Active Approach, Student Value Edition Plus MyLab Engineering with Pearson eText - Access Card Package (4th Edition)
- 2. (If relevant) A clearly labeled diagram (or diagrams) clearly pertaining to your analysis with a coordinate system and relevant labels. Final answer with appropriate units and significant figures. You can use the fprintf() command in MATLAB to format numerical results A 2-3 sentence reflection on your answer. Does it make sense? Why or why not? What are some implications?arrow_forwardPlease not Ai generated, show all steps in need to understand. Use table vaules thermodynamics engineering aprproch 10th.arrow_forwardEngineering Economy A company has determined the price and the monthly demand of its products are related by the equation D = √775 - p, where p is the price per unit in dollar and D, is the monthly demand. The associated fixed costs are $2,125 per month and the variable costs are $100/ unit. Use this information to answer the following: a)What is the optimal number of units that should be produced and sold each month? b) What is the maximum profit? c)Determine the value of D that represents the break-even point?arrow_forward
- The following tools / resources may be useful for you to complete the assignment:a. Chatgpt (You may use it to learn Matlab coding or any other computer language. An example is given here: https://shareg.pt/mXHGne9 ). Please take note that code generated by chatgpt can be directly copied and pasted.b. Matlabi) Useful cheat sheet (https://n.ethz.ch/~marcokre/download/ML-CheatSheet.pdf)ii) Getting started with Matlab (https://matlabacademy.mathworks.com/en/details/gettingstarted )iii) Getting 30-day Matlab trial license (https://www.mathworks.com/campaigns/products/trials.html ) iv) Polyfit (https://www.mathworks.com/help/matlab/ref/polyfit.html )v) Exponential Fit (https://www.mathworks.com/matlabcentral/answers/91159-how-do-i-fit-an-exponential-curve-to-my-data)c. PlotDigitizer (https://plotdigitizer.sourceforge.net/ ) or a free online app that does not requires installation (https://plotdigitizer.com/app )You may use your own engineering judgement to make any assumptions on any…arrow_forward[Engineering Thermodynamics] Please finish the answer with a diagram for reference to me (if needed). Show the answer step by step and clear to see. If you need to answer with words, please type directly. (to avoid cant see clear by handwriting) Thank you. P.S. Use the online software http://www.peacesoftware.de/einigewerte/r134a_e.html or property table and p-h diagram for R134a where necessary.arrow_forwardProcess Fluid Mechanics for Chemical Engineers , please help in this Question , thanks.arrow_forward
- The below results are for cooling tower expirement, energy balance :energy balance of the system, that is to say, the energy taken by the air must be equal to the energy supplied by the water flow. Question : Discuss the tabulated cooling tower results... Discuss in detail format!arrow_forwardPLEASE ANSWER THEM ALL FOR AN UPVOTE. THANK YOU. Given: Pi constant to be used: 3.14159 Capillary tube: radius = 0.02 cm; length = 9 cm; pressure = 0.7 mmHg Liquid sample: density = 4 ml; time of flow = 4.5 seconds Ans. the ff questions. •What is the pressure in MKS unit? •What is the pressure in CGS unit? •What is the viscosity of the liquid? • If the weight was given as 8.5 grams, what will be the density of the liquid? •What is the kinematic viscosity of the liquid? •What is the fluidity of the liquid?arrow_forwardPlease anwer the quesiton correctly and take your time, i read the guideline and honor code and im allowed to have Submit only one question at a time under the appropriate subject. A question can have up to 3 subparts (i.e. part a, b, and c). Here is the link that says from bartleby if you odnt belive me: https://bartleby.zendesk.com/hc/en-us/articles/360017462394-How-can-I-ensure-my-questions-get-answered-as-quickly-as-possible-So answer all the questions thanks.Calculate the frequency of a radio wave.1. A) radio wave has a wavelength of 21 cm. What is the wavelength in meters? (Give your answer in meters rounded to exactly 2 decimal places).B)Use your previous answer and the speed of light (c = 3 · 108 m/s) to calculate the frequency of a 21 cm radio wave. Give your answer in Hz, no decimal places.C)Use your previous answer to calculate the frequency of a 21 cm radio wave. This time, give your answer in GHz, rounded to exactly one decimal place. (Note that 1 GHz = 109 Hz).arrow_forward
- Help me!! Using the table below. Help me graph and find the graphing equation and step by step calculations on finding the fuel efficiency on a car weighing 3,300. How to get obtain these following areas in the graph. Click insert and select "Line" or "Sparklines." You should obtain a graph of your findings. Use the graph and click on a point within the graph to highlight all points with the graph. Right click and select the option to "Trendline." Select the options "Linear" and "Add equation to chart." Select on option to obtain your equations. Using this equation find the fuel efficiency of a car that weighs 3,300 pounds. show step by step calculation after obtaining the graph equations. Then, SWOT analysis: Highlight your findings for column two and three using the selection tool in Excel. Year, Name, Make | Weight | Milage per gallon (city) 2023 Toyota Pruis 3199 57 2023 Hyundai Elantra Hybrid 3069 50 2023 Hyundai Sonata Hybrid 3505 51 2023 Toyota Camry Hybrid 3528 51…arrow_forwardPLEASE ANSWER COMPLETELY WITH BRIEF EXPLANATION EACH STEP. PROVIDE FBD'sarrow_forwardEngineering Mechanics IIA man shooting a ball to ring 19.68 ft high from the ground has a velocity of 16.2 m/s. If the angle made by the man is 38 degrees, determine the distance (in m) from where the man is shooting.you can download the book we are using through this link (it should help in getting the right answer) :https://drive.google.com/file/d/1Ws-HdkaO4OAfTMa1crhsf63rbClZUCl5/view?usp=sharingarrow_forward
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY