Questions
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...

General guidelines:

Use EXCEL or PHStat to do the necessary computer work.

Do all the necessary analysis and hypothesis test constructions, and explain completely.

Read the textbook Chapter 13. Imagine that you are managing a mobile phone company. You want to construct a simple linear regression model to capture and represent the relationship between the number of customers and the annual sales level for a year with 95% confidence. You had conducted a pilot study for the past fifteen years and collected yearly observations as given in the following data.Where the number of customers in a year is represented by the Profiled Customers variable, measured by million customers unit, and the sales level is represented by the Annual Sales variable, measured by million US-dollars unit.

1) Investigate the agreement between the model and the data set for:

A) LINEARITY.

A1) Construct the "Dot Plot", a.k.a. "Scatter Plot," for this data. Visually inspect for the linear relationship between the number of customers and the sales level. Make comments based on your observations.

A2) Conduct the F-Test for linearity.

A3) If you have seen evidence of linearity in the F-Test, then:

Conduct the t-Test for the partial slope.

Construct the 95% Confidence Interval Estimator for the partial slope.

Thus, make comments about the linear relationship between the Profiled Customers and the Annual Sales, based on the partial slope information.

B) NORMALITY.

Construct the "Normal Probability Plot" for the Annual Sales variable, and make comments about the normality of annual sales level, based on your observations.

C) HOMOSCEDASTICITY.

Construct the "Residual Plot" and make comments about the variance of annual sales level, based on your observations.

D) INDEPENDENCE.

This data set is a Time-Series. Hence, investigate for the independence of observations in this time-series, based on the Durbin-Watson test.

2) If there is evidence of agreement between the model and data, and independence of observations, then construct the simple linear regression equation for this data set, based on the least square error method.

2A) Construct the 95% confidence interval for the actual average annual sales level for all the years that you have 5 million customer in a year,

2B) Construct the 95% prediction interval for the actual annual sales level for one year that you have 5 million customers in that year.

Years Profiled Customers Annual Sales
1 3.7 5.7
2 3.6 5.9
3 2.8 6.7
4 5.6 9.5
5 3.3 5.4
6 2.2 3.5
7 3.3 6.2
8 3.1 4.7
9 3.2 6.1
10 3.5 4.9
11 5.2 10.7
12 4.6 7.6
13 5.8 11.8
14 2.9 4.1
15 3 4.1

In: Math

Consider an exchange economy with 258814 people and 14512 goods and assume each good is traded...

Consider an exchange economy with 258814 people and 14512 goods and assume each good is traded under perfectly competitive conditions. How many equations must be solved to find the (general) equilibrium in this economy?

In: Economics

This is essay topic What was the Afroeurasian trade network? Use specific examples of who was...

This is essay topic

  1. What was the Afroeurasian trade network? Use specific examples of who was involved, what they traded. Explain the deterioration of the Afroeurasian trade network which existed from the 12th-14th century.

In: Economics

b) Write brief notes about the key features, relevance and there role in the capital markets...

b) Write brief notes about the key features, relevance and there role in the capital markets for the following: I. Private Equity Funds II. Venture Capital Funds III. Exchange Traded Funds

In: Finance

Use the following information to answer the next two questions On December 31, 2012, Shasha Corporation...

Use the following information to answer the next two questions
On December 31, 2012, Shasha Corporation made an adjusting entry to recognize the correct amount of unearned revenue now earned. Originally, the revenue was recorded in a real account when received.
1. The journal entry on December 31, 2012 would include a debit to which type of account?
A. Asset
B. Liability
C. Owners’ Equity
D. Revenue
E. Expense
2. The journal entry on December 31, 2012 would include a credit to which type of account?
A. Asset
B. Liability
C. Owners’ Equity
D. Revenue
E. Expense


Use the following data for the next five questions:
A partially completed bank reconciliation for RACE Company at December 31, 2012, as well as additional data necessary to answer the questions, follow:
RACE COMPANY
Bank Reconciliation
December 31, 2012
Balance per books $ 15,650
Add: (1)
Deduct: (2)
Adjusted cash balance $
  
Balance per bank statement $ 21,010
Add: (3)
Deduct: (4)
Adjusted cash balance $
Differences between book records and bank statement on December 31, 2012 are as follows:
a. Bank debit memo of $190 for bank fees on overdrawn accounts from December 16-19, 2012.
b. Check no. 2022 (for supplies) was written for $890 but erroneously recorded in Race’s records as $980.
c. An NSF check of Marcy Co., one of Race’s customers), was returned by the bank; amount was $1,900.
d. Check no. 2422 (for insurance) was written for $1,720 but erroneously recorded in Race’s records as $1,270.
e. Deposits in transit at December 31, 2012, totaled $2,720.
f. Outstanding checks at December 31, 2012 totaled $3,700.
g. Bank credit memo of $7,160 for proceeds of note receivable collected by bank for Race on December 28, 2012. $7,000 principal and $160 interest.
h. Bank service charge for December, $280.
i. Bank debit memo for $90 for safe deposit box rental at bank.
j. Bank credit memo for $40 for interest income on Race’s account.
3. In Race’s completed bank reconciliation at December 31, 2012, what dollar amount should be deducted from the balance per bank statement [indicated by (4) above]?
a. $3,700
b. $5,600
c. $3,370
d. $4,150
e. None of the above.
4. In Race’s completed bank reconciliation at December 31, 2012, what dollar amount should be added to the balance per Race’s records [indicated by (1) above]?
f. $7,290
g. $7,740
h. $7,280
i. $7,160
j. None of the above.
5. In Race’s completed bank reconciliation at December 31, 2012, what dollar amount should be deducted from the balance per Race’s records [indicated by (2) above]?
a. $3,100
b. $2,820
c. $2,630
d. $1,100
e. None of the above.
6. In Race’s completed bank reconciliation at Decemberl 31, 2012, what dollar amount should be added to the balance per bank statement [indicated by (3) above]?
a. $2,810
b. $2,760
c. $2,910
d. $2,720
e. None of the above.
7. In Race’s journal entries to correct the Cash book balance on December 31, 2012, the entry for the NSF check would be
a. Debit Cash and credit Accounts Receivable for $1,900.
b. Debit Accounts Payable and credit Cash for $1,900.
c. Debit Accounts Receivable and credit Cash for $1,900.

In: Accounting

The average retail price of Gasoline(all types) for the first half of 2005 was 212.2 cents....

The average retail price of Gasoline(all types) for the first half of 2005 was 212.2 cents. What would the standard deviation have to be in order for a 24% probability that a gallon of gas costs less than $1.80? Round z-value calculations to 2 decimal places and final answer to the nearest cent

In: Statistics and Probability

TRUE OR FALSE The wave of privatizations of public equity REITs that occurred from 2005 through...

TRUE OR FALSE

The wave of privatizations of public equity REITs that occurred from 2005 through the first half of 2007 was driven, in great part, by the availability of plentiful and cheap debt capital. This trend then reversed due to the lack of debt capital following the Global Financial Crisis, and may now be repeating itself.

In: Finance

Macro Company has the following adjusted accounts and balances at June 30: Macro Company has the...

Macro Company has the following adjusted accounts and balances at June 30:

Macro Company has the following adjusted accounts and balances at June 30:

Accounts Payable $ 370
Accounts Receivable 620
Accumulated Amortization 185
Accumulated Depreciation 320
Cash 1,090
Common Stock 370
Deferred Revenue 135
Depreciation Expense 145
Equipment 1,470
Income Tax Expense 145
Income Tax Payable 40
Interest Expense 215
Interest Revenue 60
Notes Payable (long-term) 1,370
Office Expenses 890
Prepaid Rent 50
Rent Expense 470
Retained Earnings 155
Salaries and Wages Expense 730
Sales Revenue 3,835
Software 235
Supplies 780

How do you prepare an adjusted trial balance for Macro Company at June 30?

In: Finance

. An analyst in a daily business segment broadcasted on the national TV quoted the following...

. An analyst in a daily business segment broadcasted on the national TV quoted the following statement:                                                                                                                           

“Looking at the historical market prices of AB and CD stocks, we find that AB have been on an average traded at Rs. 120 for last three years, indicating low beta because its price moved very little. On the other hand, CD stock showed that it has been traded at a high of Rs. 1050 and a low of Rs. 550 (its current market price) during the same time period as stock AB. Thus, CD stock has shown large variation in terms of its stock prices indicating a high beta.” Do you agree with his statement? Explain

In: Finance

Which of the following statements is likely to be true? A)Everything else equal, an increase in...

Which of the following statements is likely to be true?

A)Everything else equal, an increase in the supply of dollars in exchange for pesos will cause the dollars to depreciate against the pesos and will decrease the quantity of dollars being traded in the foreign exchange market.

B)If a country wants to keep the domestic currency overvalued against a foreign currency, it will buy the domestic currency and sell the foreign currency.

C)If a country wants to keep a foreign currency undervalued against the domestic currency, it will buy the foreign currency and sell the domestic currency.

D)Everything else equal, a decrease in the supply of dollars in exchange for pesos will cause the dollars to depreciate against the pesos and will decrease the quantity of dollars being traded in the foreign exchange market.

In: Economics