Using Kaggle 80 cereals by Chris Crawford do this assgnment please use pictures; All analyses must be completed using Microsoft Excel, and your submitted file must include both the raw dataset and all calculations, charts, and outputs.
1. Dataset Selection
- Download a dataset containing at least 50 observations from Kaggle or any other reputable data source.
- The dataset must be included in your Excel file.
2. Descriptive Statistics
Using Excel, calculate:
Measures of Central Tendency
- Mean
- Median
- Mode
Measures of Dispersion
- Range
- Variance
- Standard deviation
Distribution Shape
- Identify whether the data is symmetric, left-skewed, right-skewed, or approximately uniform, and briefly explain your conclusion.
3. Data Visualization
Create Excel charts to represent your data:
- Bar Chart
- Box Plot
All charts must be clearly labeled and included in your Excel file.
4. Correlation and Regression Analysis
If your dataset contains more than one variable (two variables are sufficient):
- Calculate the correlation coefficient
- Perform regression analysis and find the equation of the line of best fit
- Create a scatter plot showing the relationship between the two variables
Grading Breakdown (100 points total)
- Dataset included & properly formatted: 10 points
- Descriptive statistics: 30 points
- Visualizations (charts & box plots): 20 points
- Correlation & regression analysis: 40 points
Get this or a similar paper done in as fast as 4 hours, 24/7.
NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions
✔Secure Service ✔ Plagiarism Free ✔On-time Delivery
Leave a Reply
You must be logged in to post a comment.