NAME : MOHAMED ABDULQADR MOHAMED
SECTION : KOE58
COURSE CODE: MGN909
ROLL NO : 22
REG NO : 11801223
Q1)
First to download the excel sheet go to Sample Excel Spreadsheet - Microsoft
go.microsoft.com › fwlink.
To upload Microsoft, excel in spss go to CLICK FILE->OPEN->DATA->LOOK IN (TO LOOK
WHERE IS YOUR EXCEL SHEET IS LOCATED)->(CHOOSE)->FILE TYPES (THERE IS
OPTIONS THAT IS PROVIDIG SPSS SOFTWARE TO CHOOSE YOUR EXCEL SHEET
DATA TO UPLOAD IN SPSS)-> CLICK OPEN.
Q2)
Calculating the statical of unit sold ( mean, median, mode, Skewness, kurtosis ) unit sold
Statistics
Units Sold
N Valid 700
Missing 0
Mean 1608.294
Median 1542.500
Mode 727.0
Skewness .436
Std. Error of Skewness .092
Kurtosis -.315
Std. Error of Kurtosis .185
Q3)
Crosstabulation of country and product
Case Processing Summary
Cases
Valid Missing Total
N Percent N Percent N Percent
Country * 700 100.0% 0 0.0% 700 100.0%
Product
Case processing summary is showing there is no missing value all the numbers country
and product are complete number
Country * Product Crosstabulation
Count
Product
Amarilla Carretera Montana Paseo Velo VTT Total
Country Canada 18 20 18 42 20 22 140
France 18 18 20 40 22 22 140
Germany 18 20 18 40 22 22 140
Mexico 20 18 20 40 22 20 140
United States of 20 17 17 40 23 23 140
America
Total 94 93 93 202 109 109 700
Total number of Amarilla product in all countries are 94
Total number of Carretera product in all countries are 93
Total number of Montana product in all countries are 93
Total number of Paseo product in all countries are 202
Total number of Velo product in all countries are 109
Total number of VTT product in all countries are 109
In Amarilla : Canada,France,Germany they total same number of production. , Mixico
and United States of America also they have same production of amarilla
Carretera : Canada and Germany the have equal production of Carretera , also
France and Mixico they have same production of Carretera but United States of
America have lowest Carretera production
Montana: Canada and Germany the have equal production Montana also France
and Mixico they have same production of Montana, but United States of America
have lowest Montana production
Paseo: Canada have largest number of product Paseo but other four countries the have
same production of
Paseo
Velo: United States of America have largest production of velo and canda have lowest
production , but other three country have same equal production
VTT: : United States of America have largest production of VTT but other have same
production amount VTT
Q4)
Chia-square segment and product
Chi-Square Tests
Asymptotic
Significance
Value df (2-sided)
a
Pearson Chi-Square 11.646 20 .928
Likelihood Ratio 11.035 20 .945
N of Valid Cases 700
a. 0 cells (0.0%) have expected count less than 5. The
minimum expected count is 13.29.
Pearson Chi-Square Value is 11.646
Asymptotic Significance (2-sided): the Pearson Chi-Square its showing to reject the
alternative hypothesis and except null hypothesis because of Here the value of chai
square is more than 0.05 so that there is no association between or segment and the
product
Q5)
Calculation of correlation between sale price and sales
Correlations
Sale Price Sales
Sale Price Pearson Correlation 1 .806**
Sig. (2-tailed) .000
N 700 700
Sales Pearson Correlation .806** 1
Sig. (2-tailed) .000
N 700 700
**. Correlation is significant at the 0.01 level (2-tailed).
the correlation table is containing two column and two rows
the perfect correlation is +1 and -1
sales price is perfect positive correlated and sales is perfect positive correlated both it’s
showing +1
The correlation it’s showing 0.01 in significant level.
Sale Price and sales are are linear relationship
Q6)
Calculate partial correlation between sale price and sales with discount as a control
variable.
Correlations
Control Variables Sale Price Sales
Discounts Sale Price Correlation 1.000 .641
Significance (2-tailed) . .000
df 0 697
Sales Correlation .641 1.000
Significance (2-tailed) .000 .
df 697 0
Discount is the controlling variable
The significant value is .000 it’s showing highly significance value
The correlation between Sales Price and Sales there is significance by controlling
Discount
Q7)
Calculation of regression between profit and unit sold
Variables Entered/Removeda
Variables Variables
Model Entered Removed Method
1 Units Soldb . Enter
a. Dependent Variable: Profit
b. All requested variables entered.
Model Summaryb
Adjusted R Std. Error of
Model R R Square Square the Estimate
1 .228a .052 .051 9223.3720368
54777000
a. Predictors: (Constant), Units Sold
b. Dependent Variable: Profit
This table provide R and R squire value represent simple correlation and it’s R .228
R squire indicated high degree of correlation .
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 66695700464 1 66695700464 38.429 .000b
.255 .255
Residual 12114056572 698 1735538190.
12.970 850
Total 12781013576 699
77.225
a. Dependent Variable: Profit
b. Predictors: (Constant), Units Sold
This table indicates that the regression model predicts the dependent variable
significantly well.
This indicates the statistical significance of the regression model.
Coefficientsa
Standardized
Unstandardized Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 6022.858 3318.839 1.815 .070
Units Sold 11.261 1.817 .228 6.199 .000
a. Dependent Variable: Profit
The Coefficients table provides us with the necessary information to predict profi from
unit sold as well as determine whether profit contributes statistically significantly to the
model.
Residuals Statisticsa
Std.
Minimum Maximum Mean Deviation N
Predicted Value 8275.058593 9223.372036 9223.372036 9223.372036 700
750000000 854777000 854777000 854777000
Residual - 9223.372036 -.0000000000 9223.372036 700
9223.372036 854777000 14580 854777000
854777000
Std. Predicted -1.624 3.325 .000 1.000 700
Value
Std. Residual -1.918 5.217 .000 .999 700
a. Dependent Variable: Profit
This Residuals table it’s showing the predicted value their Maximum, Minimum, Mean, Std.
Deviation
