1. Using the data in the Excel file Banking Data, check if a linear relationship

1. Using the data in the Excel file Banking Data, check if a linear relationship exists between the variables Average Bank Balance and Median Years of Education. Construct a scatter chart and fit a trendline. 2. For the data in China Trade Data, set up a scatter plot and add a trendline to determine if a linear relationship exists between US imports (Y) and US exports (X). Also, find the estimated imports for a year when the exports were equal to 40 (billion $).

You may also like