How to Analyze
Any software, including MS Excel can be used to perform simple linear regression. Video 1 shows the simple linear regression analysis using MS Excel and Minitab.
Table 1 provides data for the fuel cost and the distance traveled by a vehicle.
Table 1
Fuel Cost vs Distance Traveled Data
Simple linear regression analysis is performed using the Minitab Software version 19. The output is provided in Figure 4.
Figure 4. Simple Linear Regression Analysis Output for the Fuel Cost vs Distance Data