Differences of French and Japanese economy Comparison Paper 1.Please the stat project requite2.I need 6 pages include two pages of Excel form3.The research

Differences of French and Japanese economy Comparison Paper 1.Please the stat project requite2.I need 6 pages include two pages of Excel form3.The research topic Japan and France. GDP current
France
1.3765E+12
1.4943E+12
1.8405E+12
2.1157E+12
2.1961E+12
2.3186E+12
2.6572E+12
2.9184E+12
2.6902E+12
2.6426E+12
2.8614E+12
2.6838E+12
2.8111E+12
2.8522E+12
2.4382E+12
2.4651E+12
2.5825E+12
Japan
4.3035E+12
4.1151E+12
4.4457E+12
4.8151E+12
4.7554E+12
4.5304E+12
4.5153E+12
5.0379E+12
5.2314E+12
5.7001E+12
6.1575E+12
6.2032E+12
5.1557E+12
4.8504E+12
4.395E+12
4.9493E+12
4.8724E+12
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.62351198
R Square
0.38876719
Adjusted R Square
0.3451077
Standard Error 3.2106E+11
Observations
16
ANOVA
df
Regression
Residual
Total
SS
MS
F
Significance F
1 9.1787E+23 9.1787E+23 8.90452959 0.00985832
14 1.4431E+24 1.0308E+23
15 2.361E+24
Coefficients Standard Error
t Stat
P-value
Lower 95% Upper 95%
Intercept
4.1842E+11 6.9318E+11 0.60362796 0.55574579 -1.068E+12 1.9052E+12
4.3035E+12 0.41230726 0.13817055 2.98404584 0.00985832 0.1159609 0.70865362
GDP growth
France
1.95444942
1.11845689
0.81953167
2.78642411
1.60771381
2.3749469
2.36149887
0.19529477
-2.9413411
1.96565738
2.19270065
0.31313474
0.57632668
0.95618304
1.11291234
1.17105015
2.16115809
Japan
0.4063359
0.11799278
1.52822015
2.20468788
1.66267041
1.42000656
1.65418388
-1.0935406
-5.4164128
4.19173926
-0.1154213
1.49508959
2.00026784
0.37471948
1.35382311
0.93819389
1.73455423
SUMMARY OUTPUT
Regression Statistics
Multiple R
0.79681143
R Square
0.63490846
Adjusted R Square
0.60883049
Standard Error 0.84609661
Observations
16
ANOVA
df
Regression
Residual
Total
Lower 95.0% Upper 95.0%
-1.068E+12 1.9052E+12
0.1159609 0.70865362
SS
MS
1 17.4291933 17.4291933
14 10.0223127 0.71587948
15 27.451506
Coefficients Standard Error
t Stat
Intercept
0.7098691 0.23143256 3.06728276
0.4063359 0.52763949 0.10693469 4.93422201
F
Significance F
24.3465468 0.00021981
P-value
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
0.00835813 0.21349563 1.20624257 0.21349563 1.20624257
0.00021981 0.2982874 0.75699159 0.2982874 0.75699159
Dear All,
This is a reminder that you should start doing your data project this weekend
in case you have any questions to ask me next week.
Guideline
Step 1: Go to
https://data.worldbank.org/indicator and select the data
based on your interesting research question.
Step 2: Download them by looking at excel on the right side.
Step 3: Organize the data from wide to long by using filter, copy and paste
special (transpose) See examples shown in class on blackboard.
Step 4: Follow the questions Q1-Q8
Step 5: Come to my office if you cannot do it and have questions!
Final Project
kittiyaratch.thanakornmonkkonchai@cgu.edu and kthanakornmonkkoncha@laverne.edu, including
the raw data and output results.
Please submit one assignment per group with names of group members on the front page. There will
be a component of graphs, data, and writing by using Microsoft Word. Make sure your graphs are good
quality and easy to understand. Data should be shown in tables. Your explanation should be in
complete paragraph form and flow logically underneath the results. You can use your own data set and
set up your own research questions by following questions below. You can choose one of these two
examples.
You must answers all questions below.
1. Research the relationship between an independent variable (X) and a dependent variable (Y), what
type of relationship do you expect (Positive, negative, none)? Explain. (1 paragraph)
2. Make a scatter plot that shows the relationship between an independent variable (X) and a
dependent variable (Y).
3. Descriptive Statistics: State the maximum, minimum, average, standard deviation and skewness for
each variable. (Comment on any interesting findings)
4. Select both one and two data sets and decide which hypothesis testing discussed in class should be
used and matched with you data set. Construct a 99% confidence interval for a mean difference and
Test at a 1% significance level. Use either the P-value or the critical-value approaches to make this test
and interpret your results
5. Correlation Analysis: Calculate the correlation coefficient (r). Does your value for r indicate a positive
or negative relationship between the two variables Comment on the strength of the relationship
between the two variables? (1 paragraph)
6. Regression analysis. Using Excel calculate the regression equation. Interpret and comment on the
slope of the equation and the intercept. (1 paragraph)
7. Conduct a test of hypothesis to determine whether the slope of the regression line is greater than
zero. Use the .05 significance level. Interpret your findings in a brief report. (1 paragraph)
8. Coefficient of determination. What percentage of the variation in y is accounted for by x? Is this a
strong regression? (1 paragraph)
Examples I: Research Question: Do poor countries save more or less than rich countries?
1. Research the relationship between savings rates and real GDP per capita, what type of relationship do
you expect (Positive, negative, none)? Explain. (1 paragraph)
2. Make a scatter plot that shows the relationship between savings rates and real GDP per capita in
2009, putting GDP per capita on the horizontal axis and savings rates on the vertical axis.
3. Descriptive Statistics: State the maximum, minimum, average, standard deviation and skewness for
each variable. (Comment on any interesting findings)
4. Select both one and two data sets and decide which hypothesis testing discussed in class should be
used and matched with you data set. Construct a 99% confidence interval for a mean difference and
Test at a 1% significance level. Use either the P-value or the critical-value approaches to make this test
and interpret your
5. Correlation Analysis: Calculate the correlation coefficient (r). Does your value for r indicate a positive
or negative relationship between the two variables Comment on the strength of the relationship
between the two variables? (1 paragraph)
6. Regression analysis. Using Excel calculate the regression equation. Interpret and comment on the
slope of the equation and the intercept. (1 paragraph)
7. Conduct a test of hypothesis to determine whether the slope of the regression line is greater than
zero. Use the .05 significance level. Interpret your findings in a brief report. (1 paragraph)
8. Coefficient of determination. What percentage of the variation in y is accounted for by x? Is this a
strong regression? (1 paragraph)
Example II. Physical Capital and GDP Growth: Do rich countries have more physical capital?
1. Research the relationship between physical capital and real GDP per capita, what type of relationship
do you expect (Positive, negative, none)? Explain. (1 paragraph)
2. Make a scatter plot that shows the relationship between physical capital and real GDP per capita in
2009, putting GDP per capita on the horizontal axis and physical capital on the vertical axis.
3. Descriptive Statistics: State the maximum, minimum, average, standard deviation and skewness for
each variable. (Comment on any interesting findings)
4. Select both one and two data sets and decide which hypothesis testing discussed in class should be
used and matched with you data set. Construct a 99% confidence interval for a mean difference and
Test at a 1% significance level. Use either the P-value or the critical-value approaches to make this test
and interpret your results.
5. Correlation Analysis: Calculate the correlation coefficient (r). Does your value for r indicate a positive
or negative relationship between the two variables Comment on the strength of the relationship
between the two variables? (1 paragraph)
6. Regression analysis. Using Excel calculate the regression equation. Interpret and comment on the
slope of the equation and the intercept. (1 paragraph)
7. Conduct a test of hypothesis to determine whether the slope of the regression line is greater than
zero. Use the .05 significance level. Interpret your findings in a brief report. (1 paragraph)
8. Coefficient of determination. What percentage of the variation in y is accounted for by x? Is this a
strong regression? (1 paragraph)

Purchase answer to see full
attachment