Skip to content

In this project, I analyzed whether the new website platform features, introduced in 2022, have increased student engagement for 365 Data Science using Microsoft Excel

Notifications You must be signed in to change notification settings

ENGINEER-LUMZ/Customer-Engagement-Analysis-for-365-Data-Science

Repository files navigation

"# Customer-Engagement-Analysis-for-365-Data-Science"

DESCRIPTIVE STATISTICS: I applied the AVERAGE, MEDIAN, and STDEV.S Excel functions to the ‘minutes_watched’ column to compute the mean, median, and standard deviation for both groups (free- and paid-plan students).

SKEWNESS AND KURTOSIS: I applied the SKEW AND KURT function to compute the skewness and kurtosis for both groups (free- and paid-plan students).

CONFIDENCE INTERVALS: I used the z-statistic to perform calculations for confidence intervals to determine the minute interval within which we can be 95% confident that a randomly selected student will be situated for both groups of students who engaged in Q4 2021 and Q4 2022.

HYPOTHESIS TESTING (Q4/21 VS Q4/22): Performed a two-sample f-test for variances to proof the assumption of unequal variances. performed a two-sample t-test to test the null hypothesis that the engagement (minutes watched) in Q4 2021 is higher than or equal to the one in Q4 2022 (μ1 ≥ μ2).

HYPOTHESIS TESTING (US VS India): Performed a two-sample f-test for variances to proof the assumption of unequal variances. performed a two-sample t-test to test the null hypothesis that the engagement (minutes watched) in the US is higher than or equal to that in India (μUS ≥ μIN).

About

In this project, I analyzed whether the new website platform features, introduced in 2022, have increased student engagement for 365 Data Science using Microsoft Excel

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published