Number 1 : Correlation
On a campus a study was conducted to find out the
relationship between Marketing test scores and Accounting test scores conducted
in a Management class. The results of the study were processed using Pearson
Correlation in SPSS software, the following results were obtained:
Correlations
|
|
Marketing_Scores |
Accounting_Scores |
|
Pearson
Correlation |
1 |
.852 |
Marketing_Scores |
Sig.
(2-tailed) |
|
.000 |
|
N |
15 |
15 |
Accounting_Scores |
Pearson
Correlation |
.852 |
1 |
|
Sig.
(2-tailed) |
.000 |
|
|
N |
15 |
15 |
Based on the results of data processing, answer the
following questions:
a. Mention
and explain the correlation coefficient of the results of the data processing!
b. Explain
the significance of the relationship between training scores and test scores
using a significance level of 5%.
c. What
is the amount of data (sample) used ?, Is the amount of data (sample) used
sufficient, give your analysis!
Number 2: Basic Regression
Known data from a finance company regarding the
Number of Branches or NB and the Number of Car Financing or CF in the
Multifinance company. The data obtained are as follows:
Year |
2015 |
2016 |
2017 |
2018 |
2019 |
2020 |
Number
of Branches (NB) |
7 |
9 |
10 |
12 |
13 |
15 |
Number
of Car Financing (CF) |
28 |
37 |
48 |
52 |
60 |
75 |
Using data from the Multifinance company, answer the
questions below:
a. Make
a simple regression equation.
b. Based
on a simple regression equation, make a prediction of the Number of Car
Financing (CF) of the company if the company has a Number of Branches (NB) of
743.
Number 3: Multiple Regression
The following are the results of data processing or
multiple regression output:
Summary
Modelb
|
Model |
|
R |
|
R
Square |
|
Adjusted
R |
Std.
Error of the |
Durbin-Watson |
|
|||
|
|
|
|
|
|
|
Square |
Estimate |
|
|
|
||
|
1 |
|
.995a |
.
990 |
|
.
985 |
53.32543 |
|
2.791 |
|
|||
|
|
|
|
|
|
|
Coefficientsa |
|
|
|
|
|
|
|
Model |
|
|
|
Unstandardized
Coefficients |
|
Standardized |
|
T |
Sig. |
|
||
|
|
|
|
|
|
|
|
|
Coefficients |
|
|
|
|
|
|
|
|
|
B |
Std.
Error |
|
Beta |
|
|
|
|
|
|
|
(Constant) |
|
596.209 |
|
117.360 |
|
|
|
5.080 |
.002 |
|
|
|
1 |
Product_Variant |
|
-40.047 |
|
24.966 |
|
-.210 |
|
-1.604 |
.160 |
|
|
|
Ad_Cost |
|
.004 |
.058 |
|
.016 |
|
.070 |
.947 |
|
|||
|
|
|
|
|
|
||||||||
|
|
Shop_Total |