Key Takeaways. Open your Excel spreadsheet and input your data. Use the “Data Analysis” toolpack by enabling it from the “Add-ins” menu. Select the type of statistical analysis you want to ...