Question

Hello I was wondering how could I solve this excel assignment, since I never used Excel, I have no clue how to begin and how to get the values and charts inputed into excel. Could I see an excel version on how I could do this? Please help, and thank you!
Step Instructions Points Possible Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers. Start Excel. In cells C17-J17, insert a Scatter Chart for the data illustrating the relationship between nitrogen fertilizer and the output of a particular type of wheat. Inserting a Chart On the Insert tab, in the Charts group, click the arrow next to Insert Scatter (X,Y) or Bubble Chart and choose Scatter Chart. Selecting Data Series Then in Select Data Source window, delete any series created automatically. Add new series for the given data using cells C6:C13 for the X values and cells D6:D13 for the Y values. Use D5 as the series name. Edit Chart Elements Select design Style 1 for the chart. Go to the Add Chart Elements dropdown list in the Design tab of the Ribbon. Add Production Function of Wheat as the chart title. Add Nitrogen Fertilizer (pounds) as the title for the horizontal axis and Wheat (bushels) as the title for the vertical axis. Chart Position Set the chart height and width so the entire chart fits within cells C17-J17. Add a linear trendline to the data on the chart. 3 Adding Linear Trendline Select any point on the chart and right click on it. Select the Add Trendline. In Trendline Options window select Linear with automatic trendline name. Trendline Options In Trendline Options window check the "Display equation on chart" and "Display R-squared value on chart boxes. You can grab the added equation and R-squared value and drag it to any place on the chart so that it is more visible to read. Edit Linear Trendline Double click on linear trendline. In Format Trendline, click Fill & Line. Select Red color and choose Solid dash type. Add a polynomial trendline to the data on the chart. Adding Polynomial Trendline Trendline

Answer 1

Please follow the instruction given and I am sure you would be able to produce a diagram as follows. The red dashed line represents the linear trend, which explains only 80.17% of the variation as shown by the R-squared value. Similarly, the blue dashed line represents the polynoimal trend with 99.35% R-squared.

Production function of wheat y = -0.0081x2 +2.1113x + 10.5 R = 0.9935 y = 0.6595x + 58.893 R2 = 0.8017 Wheat (bushels) 20 40 140 160 180 60 80 100 120 Nitrogen fertilizer (pounds)

Answer 2

x	y
6	123.6
10	189.9
3	84.9
6	140.4
3	84.9
8	149.4
6	148.8
5	112.8
10	198.3