Answer:
The predicted value of Revenue is $98.24.
Explanation:
The data provided is for the weekly gross revenue, the amount of television advertising and the amount of newspaper advertising.
Determine the regression equation developed to estimate the amount of weekly gross revenue based on television advertising using Excel.
Consider the Excel image for Summary Output for Weekly Revenue Vs. T.V. Adv.
The estimated regression equation with the amount of television advertising as the independent variable is:
<em>Revenue </em>= 89.31 + 1.27 <em>TVAdv</em>
Consider the Excel image for Summary Output for Weekly Revenue Vs. T.V. Adv. & News Adv.
The estimated regression equation with both television advertising and newspaper advertising as the independent variables is:
<em>Revenue </em>= 83.78 + 1.78 <em>TVAdv</em> + 1.47 <em>NewsAdv </em>
For TVAdv = $4.9 and NewsAdv = $3.9 predict the value of Revenue as follows:
Thus, the predicted value of Revenue is $98.24.
Answer:
Call for someone then you need to help them as much as you can
Answer:
73 months
approximately 6 years
Explanation:
The period of time it would take to pay off the loan can be determined using excel nper function as below:
=nper(rate,pmt,-pv,fv)
rate is the interest expressed in monthly terms which is 15.3%/12
pmt is the amount payment per month i.e $90
pv is the amount of loan which is $4250
fv is the balance of the loan after all payments have been made i.e $0
=nper(15.3%/12,90,-4250,0)= 73 months
73 months/12 months=approximately 6 years
Answer:
unlock the user cells and then protect the worksheet
Explanation:
In order for Ruth's husband, Barret not to alter other cells of the worksheet files, she has to unlock the user cells and then protect the worksheet.
By unlocking the user cells and protecting the work sheet, she has prevented her husband, Barret from making a change to other cells of the worksheet.
A worksheet refers to a sheet of paper on which one performs work. The worksheet Ruth used in he home office is the computer based work sheet (software) where she keeps records of her business transactions.
Debit Interest Expense [$480,000 x 8% x 360/360] = $38,400.00
<span>Credit Interest Payable = $38,400.00</span>
