Question: This is an excel question. The excel input statement is needed for each cell asked. Will give thumbs up for correct answers. I. Background Getting

This is an excel question. The excel input statement is needed for each cell asked. Will give thumbs up for correct answers.  This is an excel question. The excel input statement is needed
for each cell asked. Will give thumbs up for correct answers. I.
Background Getting a computer to do a complex calculation or to make
a decision based on data is great, but doesn't go much beyond

I. Background Getting a computer to do a complex calculation or to make a decision based on data is great, but doesn't go much beyond what a person is capable of doing. The computer might be able to do it faster than a person, but the gain in speed is not significant. The real power of the computer is its ability to perform a repetitive task with great speed and accuracy. Once we understand how to harness this ability, the computer moves beyond a simple calculator to an incredibly versatile tool. In this lab, you will be creating iterative solutions to three different problems. For each problem, you will need to create a flowchart do depict how you would solve it using repetition and simulate several rounds of iteration using Excel. II. Application 1: Processing Data A second application for repetition is the processing of large amounts of data. With the vast number of sensors used in current systems (your phone likely has at least 5-front camera, back camera, microphone, accelerometer, GPS), the amount of data generated is astronomical. It would be impossible person to sift through all of that data to make any meaningful conclusions. However, a computer can very quickly and easily process vast amounts of data and calculate different statistical values to help someone interpret the data. In this problem, you will simulate processing a set of yearly temperature data to determine whether the Earth is indeed warming. for a Inputs Set of temperature data Outputs: Number of years the average temperature increased Number of years the average temperature decreased Number of years the average temperature remained steady Maximum average temperature Minimum average temperature Processing Repeatedly process each temperature data point and determine whether the temperature increased or decreased and whether the temperature is currently the maximum temperature or the minimum temperature o The current temperature is potentially the maximum

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!