學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Descriptive Statistics in Microsoft Excel
內容大綱
The purpose of this note is to illustrate the use of Microsoft Excel functions for generating descriptive statistics for continuous data. These functions are common when analyzing data to provide insights for decision making. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.
學習目標
After completion of this note and its associated activities, students should be able to do the following: <ul><li>Use the Microsoft Excel functions that identify the minimum, maximum, rank, average, median, variance, and standard deviation of a single continuous variable data set.</li><li>Use the Microsoft Excel functions for computing the covariance and the correlation between two continuous variables in a data set.</li></ul>