Scribd
Upload
43 views5 pages

Sales and Test Score Analysis Report

The document outlines a series of tasks related to sales and test score data analysis, including calculations of mean, median, mode, range, variance, and standard deviation, as well as the creation of histograms and correlation coefficients. It presents solutions for each task, detailing statistical results and visualizations for sales data and test scores. The analysis also includes simple linear regression and interpretations of regression coefficients for independent variables affecting sales.

Uploaded by

frankykanojia
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
43 views5 pages

Sales and Test Score Analysis Report

The document outlines a series of tasks related to sales and test score data analysis, including calculations of mean, median, mode, range, variance, and standard deviation, as well as the creation of histograms and correlation coefficients. It presents solutions for each task, detailing statistical results and visualizations for sales data and test scores. The analysis also includes simple linear regression and interpretations of regression coefficients for independent variables affecting sales.

Uploaded by

frankykanojia
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

ROUNEIK KUMAR, BCH\22\44

ASSIGNMENT
Task 1

1. Calculate the mean, median, and mode of the sales data.


2. Calculate the range of the sales data.
3. Calculate the variance and standard deviation of the sales data.
4. Create a histogram to visualize the distribution of sales.
5. Calculate the correlation coefficient between the sales and the product
numbers.

SOLUTION

1. MEAN = 148

MEDIAN = 145

MODE = NO MODE

2. RANGE = 100

3. VARIANCE = 1173.333

STANDARD DEVIATION = 34.25395

4. HISTOGRAM OF THE FOLLOWING DATA


ROUNEIK KUMAR, BCH\22\44

250

200

150
PRODUCT
SALE
100

50

0
1 2 3 4 5 6 7 8 9 10

5. CORRELATION COEFFICIENT = 0.032141

Task 2

Sales is the dependent variable and rests are independent variables regarding the above data set.

Please carry out the following task

1. Calculate the correlation coefficients between the dependent variable (sales) and each
independent variable (advertising expense, price, and competitor price).

2. Perform simple linear regression analysis to determine the relationship between the dependent
variable (sales) and each independent variable individually.
ROUNEIK KUMAR, BCH\22\44

3. Create scatter plots with trend lines for each independent variable to visualize the relationship
with sales.

4. Interpret the regression coefficients, including the slope and intercept, for each independent
variable.

SOLUTION

1. CORRELATION= 0.995703
0.915857
0.874007

1000
900
f(x) = 3.86363636363636 x + 118.181818181818
800 R² = 0.991423670668954
700
600 ADVERTISING EXPENSE
500 Linear (ADVERTISING
Y EXPENSE)
400 Linear (ADVERTISING
EXPENSE)
300 PRICE
200 COMPETITOR PRICE

100
0
0 50 100 150 200 250
X
ROUNEIK KUMAR, BCH\22\44

Task 3

For the above data set carry out the following enquiries which are as follows

1. Calculate the mean, median, mode, range, and standard deviation of the test scores.

2. Create a histogram to visualize the distribution of the test scores.

3. Calculate the percentile rank for each student's score.

4. Determine the correlation coefficient between the test scores and the number of hours spent
studying.

5. Based on your analysis, summarize the performance of the students and draw any conclusions
you can make.

SOLUTION

1. MEAN= 80.8
MEDIAN= 81
MODE= NO MODE
RANGE= 24
STANDARD DEVIATION= 8.189424074

2. HISTOGRAM OF THE FOLLOWING


ROUNEIK KUMAR, BCH\22\44

100
90
80
70
60
50 SCORE
HOURS STUDIED
40
30
20
10
0
A B C D E F G H I J

3. PERCENTILE RANK

Point SCORE Rank Percent


100.00
2 92 1 %
8 90 2 87.50%
5 88 3 75.00%
7 82 4 62.50%

9 80 5 50.00%

6 78 6 37.50%
4 75 7 25.00%
1 70 8 12.50%
3 68 9 0.00%

4. CORRELATION= 0.973385696

You might also like