Help! I am having such a hard time with this and am completely stuck on all of the calculations and testing methods. I will be able to write the paper portion of this assignment if I can just get help on the calculations.

Here is the assignment:

SampleData for Supermarket Profits

Supermarket Number	Food Sales (tens of thousands of dollars)	Nonfood Sales (tens of thousands of dollars)	Profit (thousands of dollars)
		Y
1	305	35	20
2	129	98	15
3	189	83	17
4	175	76	9
5	101	93	16
6	269	77	27
7	425	44	35
8	195	47	7
9	282	31	22
10	203	92	23

Youhavetoindicatethepurposeofthestudyanddiscuss (notlisting)datacharacteristicsbeforeansweringquestions and interpretingtheresults oftheregression analysis.

1. Runamultipleregressionusing theabovedata.(withprofitas the dependentvariable).

Regression equation y = -10.17 + 0.027x₁+ 0.097x₂+ 0.5246x₃

1. Comparetheresultofquestion(1)withanotherregressionequationobtainedwithoutthefoodsales variable.
2. Whichofthemodel doyouprefer?Why?

1. Interpretyourresults for(1)and(2).

1. In writing your paper, you should start by indicating the purpose of the study. Also, discuss themethodologyand conclusions.
2. In writing your paper, you should start by indicating the purpose of the study. Also, discuss the methodology andconclusions.

** You can use EXCEL or any other software. ** You need to include your printout in yoursubmissions.

Thelayoutandformatofthepaper shouldincludethefollowingsections:

Titlepage,Abstract, Introduction,Method,Results, andDiscussion.

1. Abstractis averyconcise summaryofthepaper.

1. The Introductiontells the reader about the topic. Specifically, it should start with thepurpose of this paper is to examine.... What the issue is, what is known about it, and the specificfocus? Put a business context to it -- write the value added by your work or what businesses cangainfromtheknowledge ofthedeterminantsofmarket profits.

1. Empirical Resultsyou should start with a brief discussion of the descriptive statistics foreachvariable.
2. Methodyou should be able to explain what method you are using for your work. Forexample, you can start with telling the reader that the ordinary least squares method (OLS) wasusedtoobtainestimated coefficients...(Thenwritemore).Youshouldbeabletowrite theequationfrom theExcelresult. Weexpecttoseeyou...1. Using theexcelresult togeneratetheequation.
3. Findthestandarderrorofeachvariable.

1. Findthet-statofeachvariable.

1. Findthep-valueofeachvariable.
   1. The resultssection should tell what was found from the computed data. Using Chapter 10and 11 for helping you interpret your result. For instance, you should interpret the Coefficient ofDetermination(R!),F-test,t-test,p-value andetc.Inaddition,yourresultshould usethehypothesisequation.

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

Remember that in the results section there should include hypothesis testing for a t-test about eachslopecoefficientand aF-testfortheoverall regressionmodel.

EXAMPLE:

Forthet-test,itiswritten likethis:

H_":

H_$:_#0

Note:

Youhavetodecide whethertouseone-tailortwo-tailtest

Youneedtofollow chapter9materialsanddeclareyouralternativehypothesisineachcase very well

F-test:

H_":

H_$: ,or all threeare 0

(Notethat:remembertomentionwhat issuedinyourhypothesis testing).

1. TheDiscussiondescribeswhatyourfindings meaninthelightoftheinformationpresentedin the introduction. It is the interpretive segment of the paper and loops back to answer the issuesraised in theintroduction.Remember to answerquestions2 and 3.