Stephen manages a factory. He collected data on the number of items in an order and the time it took his workers to prepare it for shipping. He created the following scatterplot. If a new order has 187 items, predict the number of minutes it will take to prepare the order for shipping. To do this, use Excel to find a trendline. Then use the trendline to predict the number of minutes it will take to prepare the order for shipping. Round to the nearest whole number.items minutes40 222.2130 570.5883 482.51105 435.1648 273.7136 564.2644 220148 653.6140 730.2428 136.16168 816.9Group of answer choices800 minutes to prepare for shipping856 minutes to prepare for shipping861 minutes to prepare for shipping842 minutes to prepare for shipping

Angela calculates statistics for her company. She collected data on the number of items in an order and the profit the order made. She created the following scatterplot. If a new order has 54 items, predict the profit the order will make. To do this, use Excel to find a trendline. Then use the trendline to predict the number of dollar in profit the company can expect. Round to the nearest dollar.Items Profit48 344842 410939 473349 316345 387518 436620 445522 468035 472916 402029 514513 3555Group of answer choices$2050 in profit$2405 in profit$2108 in profit$2099 in profit

Question 4Tips(New Question)1 ptsAsa calculates statistics for his company. He collected data on the number of items in an order and the profit the order made. He created the following scatterplot. If a new order has 30 items, predict the profit this order will make. To do this, use Excel to find a trendline. Then use the trendline to predict the number of dollars in profit the company can expect. Round to the nearest dollar.Number of Items Profit21 754.958 471.627 537.0517 751.6611 65923 6595 3359 57518 76410 62017 767Group of answer choices$300 in profit$322 in profit$348 in profit$350 in pro

Asa calculates statistics for his company. He collected data on the number of items in an order and the profit the order made. He created the following scatterplot. If a new order has 30 items, predict the profit this order will make. To do this, use Excel to find a trendline. Then use the trendline to predict the number of dollars in profit the company can expect. Round to the nearest dollar.Number of Items Profit21 754.958 471.627 537.0517 751.6611 65923 6595 3359 57518 76410 62017 767Group of answer choices$348 in profit$350 in profit$300 in profit$322 in profit

Use the data shown to answer the questions that follow.Person Minutes Shopping in the Store Amount Spent on Groceries at Checkout1 46.5 140.52 55 1683 78.8 241.44 91.4 209.25 98.9 300.76 96.7 291.17 60.1 182.38 81.4 245.2Copy and paste the above data into Excel and make the most appropriate graph for these data. Make sure the x-axis represents the "Minutes Shopping in the Store" and that the y-axis represents the "Amount Spent on Groceries at Checkout."One of the values in the plot of this data does not fit the pattern of the other values. It would be called an outlier.What is the x-value and y-value of the outlier?Hint: If you hover your mouse over the points in your Excel graph it will show you the exact x-value and y-value of the point.Group of answer choices(46.5, 140.5)(55, 168)(78.8, 241.4)(91.4, 209.2)(98.9, 300.7)(96.7, 291.1)(60.1, 182.3)(81.4, 245.2)

Copy and paste the following data into Excel. Create a scatterplot of the data and use the scatterplot to determine if the data would best be represented by a linear, quadratic, or exponential trendline. Then use Excel to find the equation of the appropriate trendline. x y5 94932.94.9 67521.32.4 535.333.9 9943.324.5 44726.32.8 1264.074.7 534293.4 4357.411.4 63.314Which is the correct equation for the appropriate trendline?Group of answer choices𝑦=4.6233𝑥(5.9181)𝑦=13072𝑥2−63411𝑥+69096𝑦=23784𝑥−56454𝑦=4.1865𝑒(2.0135𝑥)