Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals.

(a) Based on the ANOVA table and t-statistics, does the regression appear significant?

(b) Calculate the Durbin-Watson Test statistic. Is there a serial correlation problem with the data? Explain.

(d) What affect might your answer in part (b) have on your conclusions in part (a)?

Thanks id advance! Will try to rate the answer ASAP. Please show your process too :)

NOTE THAT

((This should be done by R studio !))

Q: Upload your data as a CSV in R studio, then do any
cleaning or convert needed for example convert the date in your table
from character to date and NA identifiers . After do all these, run a summary statistics

R ONLY !!

In the following problem, check that it is appropriate to use the normal approximation to the binomial. Then use the normal distribution to estimate the requested probabilities.

Ocean fishing for billfish is very popular in the Cozumel region of Mexico. In the Cozumel region about 48% of strikes (while trolling) resulted in a catch. Suppose that on a given day a fleet of fishing boats got a total of 26 strikes. Find the following probabilities. (Round your answers to four decimal places.)

(a) 12 or fewer fish were caught


(b) 5 or more fish were caught


(c) between 5 and 12 fish were caught

In the following problem, check that it is appropriate to use the normal approximation to the binomial. Then use the normal distribution to estimate the requested probabilities.

It is estimated that 3.4% of the general population will live past their 90th birthday. In a graduating class of 730 high school seniors, find the following probabilities. (Round your answers to four decimal places.)

(a) 15 or more will live beyond their 90th birthday


(b) 30 or more will live beyond their 90th birthday


(c) between 25 and 35 will live beyond their 90th birthday


(d) more than 40 will live beyond their 90th birthday

Suppose the heights of 18-year-old men are approximately normally distributed, with mean 73 inches and standard deviation 2 inches.

(a) What is the probability that an 18-year-old man selected at random is between 72 and 74 inches tall? (Round your answer to four decimal places.)
  

(b) If a random sample of eleven 18-year-old men is selected, what is the probability that the mean height x is between 72and 74 inches? (Round your answer to four decimal places.)


(c) Compare your answers to parts (a) and (b). Is the probability in part (b) much higher? Why would you expect this?

The probability in part (b) is much higher because the standard deviation is larger for the x distribution.

The probability in part (b) is much higher because the mean is smaller for the x distribution.

The probability in part (b) is much higher because the standard deviation is smaller for the x distribution.

The probability in part (b) is much lower because the standard deviation is smaller for the x distribution.The probability in part (b) is much higher because the mean is larger for the x distribution.

1. Which of the following are examples of price discrimination? Explain your answers.

a. A cell phone carrier offers unlimited calling on the weekends for all of its customers.

b. Tickets to the student section for all basketball games are $5

c. A restaurant offers a 20% discount for customers who order dinner between 4 and 6 p.m.

d. A music store has a half-price sale on last year's guitars.

e. A well-respected golf instructor charges each customer a fee just under the customer's maximum willingness to pay for lessons.

At two different branches of a department store, pollsters randomly sampled 100 customers at store 1 and 80 customers at store 2, all on the same day. At store 1, the average amount purchased was $41.25 per customer with a sample standard deviation of $24.25. At store 2 the average amount purchased was $45.75 with a sample standard deviation of $34.76.

a) Construct a 95% confidence interval for the mean amount purchased per customer in Store 1 and Store 2.

b) Construct a 95% confidence interval for the difference between the means of purchases per customer of the two stores.

At two different branches of a department store, pollsters randomly sampled 100 customers at store 1 and 80 customers at store 2, all on the same day. At store 1, the average amount purchased was $41.25 per customer with a sample standard deviation of $24.25. At store 2 the average amount purchased was $45.75 with a sample standard deviation of $34.76.

a) Construct a 95% confidence interval for the mean amount purchased per customer in Store 1 and Store 2.

b) Construct a 95% confidence interval for the difference between the means of purchases per customer of the two stores.

Customers using a self-service soda dispenser take an average of 12 ounces of soda with an SD of 4 ounces. Assume that the amount would be normally distributed.

What is the probability that a randomly selected customer takes over 8 ounces of soda?

0.25

0.84   

0.95

0.75

0.66

What is the probability that a randomly selected customer takes between 14 to 16 ounces of soda?

0.17

0.24   

0.14

0.15

0.85

How many of the next 100 customers will take an average of less than 12.48 ounces?

54

70

33

45

5

ohnston Adhesives Company makes three widely used industrial adhesives: A101, A204, and B216. Sales and production information for each of the three adhesives are shown in the following table. Most of Johnston’s customers ask for a special blend of the three products, which improves heat-resistance. The additional separable processing requires additional time and materials, and the price is increased accordingly, as shown in the table. Assume that Johnston produces only for specific customer orders, so there is no beginning or ending inventory. Assume also that all of Johnston’s customers requested the heat-resistant version of the products so that all production required additional separable processing. Total joint cost for the three products is $3,425,000.

Required:

1. Calculate the unit product cost and total gross margin for each of the three product lines using the following methods: (a) physical measure method, (b) sales value at split-off method, (c) the net realizable value method, and (d) the constant gross margin percentage method. (Round intermediate calculations and cost per unit answers to 4 decimal places. Round your final answers to whole dollar amounts. Negative amounts should be indicated with a minus sign.)

7-45

Johnson adhesives company makes three widely used industrial adhesives: A101, A 204 and B216 sales and production information for each of the three adhesives are shown in the following table. Most of johnsons customers ask for a special blend of the three products which improves heat-resistance. The aditional separable processing requires additional time and materials, and the price is increased accordingly as shown in the table. Assume that johnson produces only for specific customer orders, so there is no beginning or ending inventory. Assume also that all of johnsons customers requested the heat resistant version of the product, so that all production required additional separable processing. Total joint cost for the three products is $3,500,000

Galloons sold 175,000 135,000 115,000 A101 A204 B216

Price/gal (after addit'l processing) 14 10 12

price at split-off 10 5 10

separable processing cost 550,000 125,000 625,000

required: Using 4 or more decimal points avoid rounding error, calculate the product cost and gross margin for each of the the three product lines using the following methods:

a.) physical unit method b.) sales value at split off method c.) the net realizable value method

2.) which of the four methods do you think would be preffered in this case? Why?

What are the internal control weaknesses in the following company's revenue cycle? And what are the potential impacts of these weaknesses on the organization? And give some suggested specific internal controls?

Customers place orders on the company’s website, via email, or by telephone. Due to a renewed interest in music, this year sales have increased significantly. All sales are on credit, with 17% of credit sales in the last 12 months needing to be written off as uncollectible. This included several large online orders to first-time customers who denied ordering or receiving the merchandise.

Customer orders are picked and sent to the warehouse, where they are placed near the loading dock in alphabetical sequence by customer name. The loading dock is used both for outgoing shipments to customers as well as receiving incoming deliveries. There are ten to twenty incoming deliveries every day, from a large number of sources.

The increased volume of sales orders has resulted in a large number of errors where customers have been sent the wrong items. There have also been delays in shipping as items that supposedly were in stock could not be found in the warehouse. Although a perpetual inventory is maintained, there has been no physical count of inventory for over two years. When an item is missing, the warehouse staff notes the information down in a log book. At the end of the week, the warehouse staff uses the log book to update the inventory records.

The system is configured to prepare the sales invoice only after shipping employees enter the actual quantities sent to a customer, thereby ensuring that customers are billed only for items actually sent and not for anything on back order. Terms of trade are payment within 21 days of invoicing, with a 2% discount offered for payments made within 5 days. Approximately 50% of Strings long standing repeat customers pay within the 5 days.