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 18 Solutions
Thinking Like an Engineer: An Active Learning Approach (3rd Edition)
- 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_forwardkamihq.com/web/viewer.html?state%=D%7B"ids"%3A%5B"1vSrSXbH_6clkKyVVKKAtzZb_GOMRwrCG"%5D%... lasses Gmail Copy of mom it for.. Маps OGOld Telephone Ima. Preview attachmen... Kami Uploads ► Sylvanus Gator - Mechanical Advantage Practice Sheet.pdf rec Times New Roman 14px 1.5pt BIUSA A Xa x* 三三 To find the Mechanical Advantage of ANY simple machine when given the force, use MA = R/E. 1. An Effort force of 30N is appliled to a screwdriver to pry the lid off of a can of paint. The screwdriver applies 90N of force to the lid. What is the MA of the screwdriver? MA =arrow_forwardHartley Electronics, Inc., in Nashville, producesshort runs of custom airwave scanners for the defense industry.The owner, Janet Hartley, has asked you to reduce inventory byintroducing a kanban system. After several hours of analysis, youdevelop the following data for scanner connectors used in onework cell. How many kanbans do you need for this connector?Daily demand 1,000 connectorsLead time 2 daysSafety stock 12 dayKanban size 500 connectorsarrow_forward
- e IY: %VY OLD ? د ميکانيك شهري 2021.pdf UNIVERSITY OF BASRAH - COLLEGE OF ENGINEERING DEPARTMENT OF CIVIL ENGINEERING Subject: Engineering Mechanics-Static Class: 1st year, 1st term Exam. : Semester Date: 16/3/2021 Examiner: Dr. Mazin, Dr. Aqeel, Dr.Ahid and Dr.Jaffar Time: 1.5Hours Q1] (10 Marks) A- In Fig.A , If the resultant force acting on the bracket is to be 642 N directed along the positive x axis, determine the magnitude of F. B- In Fig.B , Determine the magnitude of the resultant force acting on the screw eye and its direction measured clockwise from the x axis. C- In Fig.C , Resolve the 100N force into components along the u and v axes, and determine the magnitude of each of these components. D- In Fig.D, Determine the moment of the force about point O. 300 N 60N 25° 32 45° 60° 505 N 50° 40N Fig. A 50 N Fig. B 400 N 100N 28° 18 2.12 m Fig. C 2.12 m Fig.D Q2] (10 Marks) A- In Fig.A , Replace the loading system by an equivalent resultant force and specify where the resultant's…arrow_forward- Moos X O CIVL3106_yahiaz_sprir x Part 1 b Answered: soil mechar x elearn.squ.edu.om/mod/quiz/attempt.php?attempt3D2055593&cmid=903343 IO YouTube Maps التعلم القبلي G IG SYSTEM (ACADEMIC) raur. p Time le From the figure below determine Cc (compression index) 1.9 1.7 1.5 1.3 1.1 0.9 0.7 0.5 + 10 100 1000 Pressure (kPa) Paragraph BI Void ratio !!arrow_forwardProjects A and B are mutually exclusive. The minimum attractive rate of return (MARR) is 12%. Using rate of return analysis, which project should be selected? If the image fails to load here, go to https://www.dropbox.com/s/ld6wctqieu8jgwp/ROR.jpg Year 0 1 2 3 4 ROR A - $750 $200 $200 $200 $600 17.68% B - $1,150 $300 $350 $400 $700 16.44% O Project A O Project B O Both Project A and B O Select none of the project. O Insufficient information to make a decision. B-A - $400 $100 $150 $200 $100 13.69%arrow_forward
- Q5/The plot of the engine cycle on P-V coordinates is often called * power indicator pressure enthalpy daigram force time daigram indicator diagram Q6/In IC engine the work is generated by the gasses in the combustion chamber is * directly proportional to piston travel inversely proportional to piston travel does not depend on piston travel all of above Q7/The gas pressure force is a function of * velocity piston acceleration piston piston travel the power out put docs.google.com Aarrow_forwardO You are running an industrial research study together with your project team to improve energy efficiency in a combustion process. The purpose of the research is to identify the optimum air-fuel ratio for the combustion process in a boiler under varying conditions of air supply and quality of fuel. The study would involve design of experiments, data collection and analysis, simulation of the different variables and validation of the optimum parameters. There is a lot of pressure to improve the energy efficiency as there is a forecast of fuel price rise in the forthcoming month. Based on the CRPE code of ethics, explain two critical precautions which the engineers have to consider before implementation of the data collection process for the industrial experiment. to be taken during the Describe briefly five ethical measures experimentaldata collection in order to ensure validity of results. Explain two precautions to be taken during the report writing on the research study carried out…arrow_forwardest 2 (copy) (page 4 of 9) A wiseup.wsu.acza/mod/quiz/attempt.php7attempt=610918cmid 148960&page=3 ops O YouTube M Gmail Maps O GENERAL MATHEM. O New Tab :WSU WiSeUp 1 MONLO GOA ashboard / My courses / FLM15B2_KF_WS6222 2021 / Tests / Test 2 (copy) uestion 4 Quz navigation Gate AB in Figure below is 1.0 m long and 0.9 wide. Calculate force F on the gate and position X of its centre of Not yet answered pressure. Marked out of Finish attempt 10,000 Rag question 3m Oil, s.g.=Q81 7m 1.0m B 50 Answerarrow_forward
- You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forwardPlease provide equations that you are using so I can follow along and learn how to do this and include conversions and units. In Jamestown, NY, a coal power plan consumes coal at a rate of 80 tons/hr. When coal burns, it generates approximately 30,000 kJ for every kg of coal burned. The cooling course for the plant is the nearby Chadakoin River nearby and, by code, the power plant cannot reject more than 13.19 x 109 MJ into the river annually. Determine the maximum average power output of this plant and it's maximum thermal efficiency. To check your work, enter the efficiency, as a decimal, in the box provided.arrow_forwardM Inbox (58) - tasin5 x M It's official. Your p X My Questions | ba x G Security Checkup x G Privacy Checkup M Inbox (58) - tasin x M New assignment: X A Term Paper (Sectic X + i classroom.google.com/u/1/c/NDA5NTY×OTA5MZU0/a/NDAyNTUyNDIzNzk5/details E Apps M Gmail YouTube A Maps E Reading list Term Paper Question = Final Exam of ME 331 Determine the natural frequency of the system which is shown below. Here, springs geometries O Term Pa are similar but spring 1 made of mild steel, spring 2 made of copper, d= 5 mm, spring index = 10, Assigned Md Maruf Billah • number of active coils in the springs = 8, m2= mo, r2=r¡ = 25 mm = 0.4R = 5t and the pulleys are 100 points made of cast iron. Take other information which are necessary to solve the problem from dd or create internet/literature/book. rk as done mments Class comme k2 to Md Maruf Billah m. Add a class comm m2 k1 Center line Cross section of the springs Cross section of the pulleys Page 1 | 1 2:03 РМ Type here to search 33°C Rain…arrow_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