Supermarket Profits.pdf You have to indicate the purpose of the study and discuss (not listing) data characteristics before answering questions and interpreting the results of the regression analysis....

1 answer below »
Paper and solutions journal project. All problem are to be shown step by step and excel print out to be handed in with paper. No references are necessary as this is finding solutions to data and interpreting the results in a paper which includes:Title page, Abstract, Introduction, Method, Results, and Discussion.


Supermarket Profits.pdf You have to indicate the purpose of the study and discuss (not listing) data characteristics before answering questions and interpreting the results of the regression analysis. 1. Run a multiple regression using the above data. (with profit as the dependent variable). 2. Compare the result of question (1) with another regression equation obtained without the food sales variable. 3. Which of the models do you prefer? Why? 4. Interpret your results for (1) and (2). 5. In writing your paper, you should start by indicating the purpose of the study. Also, discuss the methodology and conclusions. ** You can use EXCEL or any other software. ** You need to include your printout in your submissions. The layout and format of the paper should include the following sections: Title page, Abstract, Introduction, Method, Results, and Discussion. a) Abstract is a very concise summary of the paper. b) The Introduction tells the reader about the topic. Specifically, it should start with the purpose of this paper is to examine…. What the issue is, what is known about it, and the specific focus? Put a business context to it -- write the value added by your work or what businesses can gain from the knowledge of the determinants of market profits. c) Empirical Results you should start with a brief discussion of the descriptive statistics for each variable. d) Method you should be able to explain what method you are using for your work. For example, you can start with telling the reader that the ordinary least squares method (OLS) was used to obtain estimated coefficients... (Then write more). You should be able to write the equation from the Excel result. We expect to see you… 1. Using the excel result to generate the equation. 2. Find the standard error of each variable. 3. Find the t-stat of each variable. 4. Find the p-value of each variable. EXAMPLE: Ŷ = 1.24 + 1.71x1 - 0.83x2 - 2.12x3 !!" (6.79) (1.43) (0.22) (0.85) T-stat [0.18] [1.20] [3.78] [2.48] P-value 0.857 0.247 0.002 0.025 e) The results section should tell what was found from the computed data. Using Chapter 10 and 11 for helping you interpret your result. For instance, you should interpret the Coefficient of Determination (R!), F-test, t-test, p-value and etc. In addition, your result should use the hypothesis equation. Remember that in the results section there should include hypothesis testing for a t-test about each slope coefficient and a F-test for the overall regression model. EXAMPLE: For the t-test, it is written like this: H":β# = 0 H$: β# ≠ 0 Note: § You have to decide whether to use one-tail or two-tail test § You need to follow chapter 9 materials and declare your alternative hypothesis in each case very well F-test: H":β# = β! =β% = 0 H$: β# ≠ β! ≠β% ≠ 0, orallthreeare ≠ 0 (Note that: remember to mention what α is used in your hypothesis testing). f) The Discussion describes what your findings mean in the light of the information presented in the introduction. It is the interpretive segment of the paper and loops back to answer the issues raised in the introduction. Remember to answer questions 2 and 3.
Answered Same DayNov 15, 2021

Answer To: Supermarket Profits.pdf You have to indicate the purpose of the study and discuss (not listing) data...

Shakeel answered on Nov 28 2021
133 Votes
Supermarket’s profit and underlying factors: An analysis on cause-effect relationship
Table of Contents
Abstract    2
Introduction    3
Methods    3
Results    5
Descriptive statistics    5
Discussion    6
Inferential statistics    6
Discussion    7
Discussion    8
Conclusion    9
References    10
Abstract
Profit to Supermarket de
pends upon the several factors from sales of items to size of supermarket, consumer preferences, location, purchasing power etc. Here, in this paper, the profit of supermarket and three underlying factors – “sales of food items”, “sales of non-food items” and “size of super market” is analyzed to test the significance of cause effect relationship between them and it is found that non-food items and size of supermarket are two significant factors responsible for generating the profit. The F test suggests that model is best fit if we include independent variables and thus, few more factors may yield more accurate result.
Introduction
The most important motive of establishing a business organization is to make profit and it is even true that without the profit a business can’t be sustained in long run. The profit of the business depends upon the several factors like Sales volume of the sold goods, price of the items, cost incurred in the production of goods and other indirect costs. Therefore, to make the profit, the sales/revenue must be higher than the cost. Profit can be sustained either through selling low volume of goods at higher price or selling higher volume of goods at lower price. However, the better controlling of costs – both direct and indirect must be lower than the sales to generate the profit.
Here, in this paper, the case of supermarkets are considered where, three major factors are identified to generate profit. First is the “Sales of food items”, second is “sales of non-food items”    and third is the “store size” that of course, shows the sales volume. Here, it is tried to find out which factor/s is/are mainly responsible to generate the profit for supermarkets.
Methods
To test the cause effect relationship between profit and underlying factors, the sales data of food and non-food items and Store size data of 10 supermarkets are taken. Then, regression analysis is conducted to check the significance of underlying factors of profit.
Linear Regression is an important statistical tool to study the cause-effect relationship between variables. According to Campbell D & Campbell S (2008), “Regression is primarily used for prediction and causal inference.” Under this model, first a dependent variable is selected that needs to be forecasted and then several other Independent variables are selected that affect the dependent variable. It means there must be some kind of relationship among the variables. Thus, in this way, regression model has one dependent variable and several Independent variables.
Linear Regression is generally of two kinds – Simple Linear regression and Multiple Linear Regressions. Simple linear regression shows the relationship between only two variables - One is dependent and other is Independent. Multiple linear regressions establish the...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here