Short Answer 
To analyze data in Excel, start by entering your x and y values in two labeled columns. Then, calculate the means, deviations, and squared deviations for both variables, followed by summing these squared deviations to obtain SSxx, SSyy, and SSxy for further analysis.
Step 1: Enter the Data
Start by entering the given data into an Excel worksheet. Ensure that you have two columns, one for the x values and another for the y values. This allows you to organize your data efficiently. Properly labeling the columns can also help in avoiding confusion later.
Step 2: Calculate Deviations and Squared Deviations
Next, calculate the mean of both the x and y values using Excel’s AVERAGE function. Once you have the means, compute the deviations as follows:
- Subtract the mean of x from each x value to find the deviation of x (x – mean(x)).
- Subtract the mean of y from each y value to find the deviation of y (y – mean(y)).
- Square each deviation to obtain the squared deviations for both x and y.
Step 3: Sum Up the Values
Finally, you need to compute the sums of the squared deviations. This involves:
- Summing all the squared deviations of x to get SSxx.
- Summing all the squared deviations of y to get SSyy.
- Multiplying the deviation of x by the deviation of y for each data point and summing these to get SSxy.
By following these steps, you’ll have the values for SSxx, SSyy, and SSxy calculated and ready for analysis.