[go: up one dir, main page]
Scribd
Upload
63 views3 pages

Descriptive Statistics - Excel Exercises

The document consists of two exercises focused on data analysis. Exercise 1 involves calculating descriptive statistics for student scores and performing a linear regression analysis based on study hours, while Exercise 2 requires creating and customizing bar and pie charts to visualize sales data across various product categories. Additionally, both exercises include a request for interpretations of the results and insights gained from the analyses.

Uploaded by

ruwis42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
63 views3 pages

Descriptive Statistics - Excel Exercises

The document consists of two exercises focused on data analysis. Exercise 1 involves calculating descriptive statistics for student scores and performing a linear regression analysis based on study hours, while Exercise 2 requires creating and customizing bar and pie charts to visualize sales data across various product categories. Additionally, both exercises include a request for interpretations of the results and insights gained from the analyses.

Uploaded by

ruwis42
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Exercise 1

Student ID Scores Study Hours

1 85 5

2 78 4

3 92 6

4 65 3

5 88 5

6 70 3

7 75 4

8 82 5

9 79 4

10 90 6

11 72 3

12 85 5

13 76 4

14 84 5

15 88 6

1. Calculate the following descriptive statistics measures for the 'Scores' column:
● Mean
● Median
● Mode
● Standard deviation
● Variance
● Range
● Minimum value
● Maximum value
● Quartiles (Q1, Q2, Q3)
2. Calculate the correlation coefficient between the 'Scores' and 'Study Hours'
columns (if available).
3. Provide a brief interpretation of the descriptive statistics results and any insights
gained from the analysis.
4. Perform a simple linear regression analysis to predict student scores based on
study hours.

Exercise 2
Product Category Sales Amount

Electronics 2500

Clothing 1800

Home Appliances 2100

Books 1500

Sports Equipment 2200

Beauty Products 1900

Toys 2000

Furniture 2400

Food 2300

Stationery 1700

1. Create a bar chart to visualize the sales figures for each product category.
2. Customize the bar chart by adding appropriate axis labels, titles, and formatting
options.
3. Create a pie chart to visualize the proportion of total sales contributed by each
product category.
4. Customize the pie chart by adding data labels, a legend, and other formatting
options.
5. Provide a brief interpretation of the bar and pie charts, highlighting any insights
gained from the visualizations.

You might also like