Analyse and present data graphically using

spreadsheet software (Excel).

2. Critically evaluate summary statistics against suitable

benchmarks.

3. Apply judgment to select appropriate methods of

data analysis drawing on knowledge of regression

analysis, probability, probability distributions and

sampling distributions.

4. Select and apply a range of data analysis tools to

inform problem solving and decision making.

5. Conduct quantitative research both individually and as

part of a team and articulate and present findings to a

wide range of stakeholders, from accounting and nonaccounting

backgrounds.

Answered 21 days AfterDec 05, 2017STAT6003Torrens University Australia

Regression analysis helps me to predict the sales of federated island, Industria, Nokaragua, and Sweden country. I am given ln(GDP), price index, population, advertisement and stores for countries federated island, Industria, Nokaragua, and Sweden country. I perform three regression analysis to predict sales of federated island, Industria and Nokaragua on basis of co

esponding ln(GDP), price index, population, advertisement and stores for each country. The values of future independent variables are predicted by using formula of growth rate. I plug in these calculated independent variables in the co

esponding regression equation for 3 countries federated island, Industria, Nokaragua in order to obtain the predicted value of sales. For the prediction of sales co

esponding to Sweden, I choose the best appropriate regression model among 3 models created for countries federated island, Industria and Nokaragua. The value of GDP/population and Price index for Sweden is compared with that of federated island, Industria and Nokaragua. The country among federated island, Industria and Nokaragua with closest GDP/population and Price to Sweden is selected to prediction of Sweden sales. Then I plug in the calculated values of independent variables (using growth rate) in the co

esponding regression equation for selected country.

There are 25 observations of sales for each country. The mean sale of federated island, Industria and Nokaragua is $713,603, $17,372,234 and $7,859,679. Industria highest mean and median of sales. And federated Island has the lowest mean and median of sales. The minimum and maximum of sales for Federated Islands, Industria and Nokaragua is ($432,967 ; $957,950) ($11,919,253 ; $23,103,581) and ($5,162,754 ; $10,554,044) respectively.

Advertisement and Stores have a strong linear relationship between them for three countries of my interest Federated Islands, Industria and Nokaragua. Hence there is problem of Multi-co-linearity. Survey store has weak linear relationship with Sales. Hence I Remove survey store as independent variable in further regression analysis. Fox, J. (1997).

For country Federated Islands, (Sales, GDP) (Sales, population 15-65) has positive linear relationship. Sales and price index have a weak negative linear relationship. The regression output is given below.

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.99731

R Square

0.994628

Adjusted R Square

0.993215

Standard E

o

14614.74

Observations

25

ANOVA

df

SS

MS

F

Significance F

Regression

5

751407540992

150281508198

703.5963

7.18053E-21

Residual

19

4058219974

213590525

Total

24

755465760966

Coefficients

Standard E

o

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

-1295339

640295.1687

-2.02303359

0.057371

-2635491.824

44814.56

-2635492

44814.56

ln(gdp)

82937.48

36853.36199

2.250472565

0.036458

5802.506939

160072.5

5802.507

160072.5

Price index

-19470

2528.258944

-7.700948584

2.94E-07

-24761.69892

-14178.3

-24761.7

-14178.3

Population 15-65

-21.1937

8.052980923

-2.631787281

0.01643

-38.04881555

-4.33865

-38.0488

-4.33865

Advertisement

42453.3

4096.434857

10.36347511

2.95E-09

33879.36399

51027.24

33879.36

51027.24

Stores

19081.54

5497.566605

3.47090629

0.002559

7574.999367

30588.08

7574.999

30588.08

There is 99.46% variation in sales which is explained by ln(GDP), price index, population 15-65, advertisement and stores. Regression equation is given by sales = -1295338.63 + 82937.488ln(GDP) - 19470*Price_index - 21.197*population + 42453.3*advertisement + 19801.54*stores. Ho: coefficient of independent...

esponding ln(GDP), price index, population, advertisement and stores for each country. The values of future independent variables are predicted by using formula of growth rate. I plug in these calculated independent variables in the co

esponding regression equation for 3 countries federated island, Industria, Nokaragua in order to obtain the predicted value of sales. For the prediction of sales co

esponding to Sweden, I choose the best appropriate regression model among 3 models created for countries federated island, Industria and Nokaragua. The value of GDP/population and Price index for Sweden is compared with that of federated island, Industria and Nokaragua. The country among federated island, Industria and Nokaragua with closest GDP/population and Price to Sweden is selected to prediction of Sweden sales. Then I plug in the calculated values of independent variables (using growth rate) in the co

esponding regression equation for selected country.

There are 25 observations of sales for each country. The mean sale of federated island, Industria and Nokaragua is $713,603, $17,372,234 and $7,859,679. Industria highest mean and median of sales. And federated Island has the lowest mean and median of sales. The minimum and maximum of sales for Federated Islands, Industria and Nokaragua is ($432,967 ; $957,950) ($11,919,253 ; $23,103,581) and ($5,162,754 ; $10,554,044) respectively.

Advertisement and Stores have a strong linear relationship between them for three countries of my interest Federated Islands, Industria and Nokaragua. Hence there is problem of Multi-co-linearity. Survey store has weak linear relationship with Sales. Hence I Remove survey store as independent variable in further regression analysis. Fox, J. (1997).

For country Federated Islands, (Sales, GDP) (Sales, population 15-65) has positive linear relationship. Sales and price index have a weak negative linear relationship. The regression output is given below.

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.99731

R Square

0.994628

Adjusted R Square

0.993215

Standard E

o

14614.74

Observations

25

ANOVA

df

SS

MS

F

Significance F

Regression

5

751407540992

150281508198

703.5963

7.18053E-21

Residual

19

4058219974

213590525

Total

24

755465760966

Coefficients

Standard E

o

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

-1295339

640295.1687

-2.02303359

0.057371

-2635491.824

44814.56

-2635492

44814.56

ln(gdp)

82937.48

36853.36199

2.250472565

0.036458

5802.506939

160072.5

5802.507

160072.5

Price index

-19470

2528.258944

-7.700948584

2.94E-07

-24761.69892

-14178.3

-24761.7

-14178.3

Population 15-65

-21.1937

8.052980923

-2.631787281

0.01643

-38.04881555

-4.33865

-38.0488

-4.33865

Advertisement

42453.3

4096.434857

10.36347511

2.95E-09

33879.36399

51027.24

33879.36

51027.24

Stores

19081.54

5497.566605

3.47090629

0.002559

7574.999367

30588.08

7574.999

30588.08

There is 99.46% variation in sales which is explained by ln(GDP), price index, population 15-65, advertisement and stores. Regression equation is given by sales = -1295338.63 + 82937.488ln(GDP) - 19470*Price_index - 21.197*population + 42453.3*advertisement + 19801.54*stores. Ho: coefficient of independent...

SOLUTION.PDF## Answer To This Question Is Available To Download

- Dr. Ding3.The initial model to consider is a first-order model which includes all sevenpredictor variables. Use statistical techniques learned in this class to analyze the model. Things to be included...SolvedDec 14, 2019
- This project gives you the chance to use the statistical techniques and concepts covered in Chapters 7-9, and Chapter 14. Overview: The U.S. Department of Agriculture maintains a nutrient database for...SolvedDec 09, 2019
- 10 2 EDUC 478: Introduction to Quantitative Research Methods Regression Handout Use the Student Engagement Dataset for this exercise 1. We are interested in investigating which variables are good...SolvedDec 09, 2019
- Directions: Answer each question below in its entirety. Submit your answers through Canvas by the due date. Your submission should be a Word document. Please round to the nearest hundredth in your...SolvedDec 07, 2019
- Answer the following questions. 1. In 1990 Congress passed the Oil Pollution Act requiring tankers to have thicker hulls to prevent oil spills. Data were collected on 42 major oil spills recording the...SolvedDec 02, 2019
- Week 7 Homework overview This week we'll be learning how to build a regression model with a classification (yes/no, 1/0) variable as our dependent variable. We will use a technique called "logistic...SolvedNov 30, 2019
- Outline The project is to use a multiple regression analysis to analyze a data set that is of interest to you. If you have a strong interest in two group or analysis of variance you can do that with...SolvedNov 27, 2019
- Research Project for 3341 The project is to use a multiple regression analysis to analyze a data set that is of interest to you. If you have a strong interest in two group or analysis of variance you...SolvedNov 27, 2019
- You must submit 1 word document with your screenshots and answers. You should also submit the file where you conducted your statistical analysis (Excel, R, Python, etc.)...SolvedNov 26, 2019
- ROCKINGHAM NATIONAL BANK VISA CARD SURVEY Company Background Rockingham National Bank, located in Chicago, is attempting to expand the market for its Visa card. It is examining certain target groups...SolvedNov 21, 2019

Copy and Paste Your Assignment Here

Disclaimer: The reference papers provided by TAE serve as model papers for students and are not to be submitted as it is. These papers are intended to be used for research and reference purposes only.

Copyright © 2022. All rights reserved.