For the data below:

(a)           Determine the least squares regression line using Excel.

(b)           Determine the predicted value for 2004.

(c)           Determine the 3 year moving average.

(d)           Determine the MSE for the trend line (in a) and the 3 year moving average (in c.) Which forecasting method is better? Explain.

need to check my answers

On November 1, 2017, the account balances of Hamm Equipment Repair were as follows.

During November, the following summary transactions were completed.

___________________________________________________________________

A.)Enter the November 1 balances in the ledger accounts.

B.)Journalize the November transactions.

c.)Post to the ledger accounts.

d.)Prepare a trial balance at November 30.

e.)Adjustment data consist of:

Journalize the adjusting entries.

Post the adjusting entries

f.)Prepare an adjusted trial balance.

All Tunes Satellite Radio (ATS) provides a subscription service to satellite radio channels. Customers can pay for a subscription on a monthly basis, or pay for a year in advance and receive a 15% discount. Approximately 53% of customers pay in advance. When ATS receives payment in advance, a deferred revenue account (Unearned Revenue) is credited. At the end of each month as the satellite radio service is provided to customers, ATS makes an adjusting entry to recognize subscription revenue. The audit team is planning a reliance on controls strategy to obtain evidence of revenue recognition for ATS. The team will be testing internal controls over the recognition of subscription revenue during interim.

Explain the type of audit strategy planned by the audit team for gathering evidence about revenue recognition.

Suppose during the interim testing of internal controls the team discovers a significant number of instances in which subscription revenue received in advance is recognized immediately as revenue. Analyze how the audit strategy will be impacted.

Historically, the average score of PGA golfers for one round is 74 with a standard deviation of 3.91. A random sample of 110 golfers is taken. What is the probability that the sample mean is between 73.63 and 74?

Question 2 options:

The general fund budget (in billions of dollars) for a U.S. state for 1988 (period 1) to 2011 (period 24) follows.

(a)

Construct a time series plot.

What type of pattern exists in the data?

The time series plot shows a horizontal pattern.

The time series plot shows a nonlinear trend.    

The time series plot shows a seasonal pattern.

The time series plot shows a linear trend.

(b)

Develop a linear trend equation for this time series to forecast the budget (in billions of dollars). (Round your numerical values to three decimal places.)

T_t =

(c)

What is the forecast (in billions of dollars) for period 25? (Round your answer to two decimal places.)

$ _______ billion

please!!!!!!!!!!!!!1

To study how social media may influence the products consumers​ buy, researchers collected the opening weekend box office revenue​ (in millions of​ dollars) for 23

recent movies and the social media message rate​ (average number of messages referring to the movie per​ hour). The data are available below. Conduct a complete simple linear regression analysis of the relationship between revenue​ (y) and message rate​ (x).

Q1: Determine the estimate of the standard deviation. s=?????

Q2: What is the test statistic for the​ hypotheses? t=??????

A suburban hotel derives its revenue from its hotel and restaurant operations. The owners are interested in the relationship between the number of rooms occupied on a nightly basis and the revenue per day in the restaurant. Below is a sample of 25 days (Monday through Thursday) from last year showing the restaurant income and number of rooms occupied.

1. Determine the coefficient of correlation between the two variables. (Round your answer to 3 decimal places.)

Pearson Correlation:

2.

c-1. State the decision rule for 0.01 significance level: H₀: ρ ≤ 0; H₁: ρ > 0. (Round your answer to 3 decimal places.)

c-2. Compute the value of the test statistic.

D. What percent of the variation in revenue in the restaurant is accounted for by the number of rooms occupied? (Round your answer to 1 decimal place.)

________% of the variation in revenue is explained by variation in occupied rooms.

To test whether the mean time needed to mix a batch of material is the same for machines produced by three manufacturers, the Jacobs Chemical Company obtained the following data on the time (in minutes) needed to mix the material.

a. Compute the values below (to 2 decimals, if necessary).

b. Use Fisher's LSD procedure to develop a 95% confidence interval estimate of the difference between the means for manufacturer 1 and manufacturer 2. Round to two decimal places. Enter negative values as negative numbers.

With individual lines at its various windows, a post office finds that the standard deviation for waiting times for customers on Friday afternoon is 7.2 minutes. The post office experiments with a single, main waiting line and finds that for a random sample of 27 customers, the waiting times for customers have a standard deviation of 4.35 minutes on a Friday afternoon. What is the Test Statistics to test the claim that a single line causes lower variation among waiting times for customers?