13.3 Working with Excel


Does Red Tomato fertilizer increase my tomato harvest by at least 20% in weight?


Working Files

13.3.1 Desktop version

Option 1

Data Analysis Tool

  • On the Data tab, in the Analysis group, click Data Analysis.
  • Select t-Test: Two-Sample Assuming Unequal Variances and click OK.
More info here and analysis toolpak
  • Click in a Range box and select the corresponding range of cells.



Option 2

Real-Statistics Tool

  • On the Complementos tab, in the Analysis group, click Data Analysis.
  • Select t-Test: Two-Sample Assuming Unequal Variances and click OK.
More info here
  • Results.

13.3.2 Cloud version

Option 2

XLMiner Analysis ToolPak

  • On the XLMiner Analysis ToolPak pane, click t-Test Paired Two-Sample for Means.
  • Complete the corresponding Ranges.
More info here
  • Results.