The Get with It Health and Wellness Center provides personal training and nutritional counseling to clients...

  

Transcribed Image Text:

The Get with It Health and Wellness Center provides personal training and nutritional counseling to clients each month. The company is relatively new and management is seeking information regarding the company's cost structure. The following information is available for costs incurred to provide the services since January. CLIENTS TOTAL COSTS January 100 $51,000 February 120 $56,400 March 150 $62,700 April 180 $71,200 May 160 $65,400 June 130 $58,200 Scattergraphing: Step 1: Put in your data set. Make sure the data columns are in XY order with contiguous columns next to each other). Step 2: Left Click and drag from the first X across and down to the last Y. (Highlight your data) Step 3: Go to and click on the INSERT tab, Go to the Charts. Step 4: Choose XY Scattergraph. Click on the default to plot your data points. Step 5: Right click on any data point and go down to "Add Trendline". Click on it. Step 6: To the right of your screen is the box with option. Leave default Linear. Step 7: Go to the box called "Backward". Put in the lowest X in your data. Step 8: Click on the box Display the equation. Step 9: Move the equation out of the line of the regression so it is clearly visible. Regression: Use the FORMULAS tab to find the slope (m) and the y-intercept (b). Use the format just like the video I provided on Canvas. Your last item here will be putting the y-mX+b in Excel for Zero clients. The Get with It Health and Wellness Center provides personal training and nutritional counseling to clients each month. The company is relatively new and management is seeking information regarding the company's cost structure. The following information is available for costs incurred to provide the services since January. CLIENTS TOTAL COSTS January 100 $51,000 February 120 $56,400 March 150 $62,700 April 180 $71,200 May 160 $65,400 June 130 $58,200 Scattergraphing: Step 1: Put in your data set. Make sure the data columns are in XY order with contiguous columns next to each other). Step 2: Left Click and drag from the first X across and down to the last Y. (Highlight your data) Step 3: Go to and click on the INSERT tab, Go to the Charts. Step 4: Choose XY Scattergraph. Click on the default to plot your data points. Step 5: Right click on any data point and go down to "Add Trendline". Click on it. Step 6: To the right of your screen is the box with option. Leave default Linear. Step 7: Go to the box called "Backward". Put in the lowest X in your data. Step 8: Click on the box Display the equation. Step 9: Move the equation out of the line of the regression so it is clearly visible. Regression: Use the FORMULAS tab to find the slope (m) and the y-intercept (b). Use the format just like the video I provided on Canvas. Your last item here will be putting the y-mX+b in Excel for Zero clients.

Answer rating: 100% (QA)

X Y January 5100000 100 February 120 S 5640000 March 150 62700... View the full answer