Reference no: EM13914012
Problem 1 (Comparing random samples and populations). Open the Excel file EAI.xlsx. The data show the annual salary for all 2, 500 managers in one company.
a. What is the population mean annual salary?
b. What is the population standard deviation for annual salary?
Now, we want to construct 10 random samples each of size 25. One way to do this is as follows:
(i) Assign a random number to each salary, so in the column adjacent to the salary column, use the RAND function generate a list of random numbers uniformly distributed between 0 and 1.
(ii) Sort salaries by their corresponding random number. This can be accomplished by using the sort feature found in the Data tab. Sort by either ascending or descending.
(iii) Take the first 25 sorted salaries as our first random sample. Copy and paste the values of these 25 salaries into a new column.
(iv) Press F9. This will reassign a new random number to each salary.
(v) Repeat steps (ii), (iii), and (iv) until you have 10 random samples of size 25.
For each of the 10 random samples,
c. Find a point estimate of the population mean annual salary. (Consider using the fill-handle here.)
d. Find a point estimate of the population standard deviation. (Consider using the fillhandle here.)
e. How do the 10 point estimates of the population mean compare to the actual population mean?
f. How do the 10 point estimates of the population standard deviation compare to the actual population standard deviation.
Problem 2. Open the Excel file GolfIncome.xlsx. The data represent income (in thousands of dollars) earned by a population of 40 professional golfers from their endorsement deals.
a. What is the probability that a golfer earned between 4, 000 and 6, 000 thousand dollars? Hint: One way to find the number of incomes between 4, 000 and 6, 000 thousand dollars is to use the COUNTIFS function.
b. How much did a golfer have to earn to be in the top 25% of the income bracket? Hint: Sort ascending the dataset, then find the (100 - 25) = 75th percentile (Recall the percentile formula back in lecture 2).
Now, assume that the data follow a normal distribution. Using the NORM.DIST and NORM.INV functions, determine the following:
c. What is the probability that a golfer earned between 4, 000 and 6, 000 thousand dollars?
d. How much did a golfer have to earn to be in the top 25% of the income bracket?
Attachment:- Assignment.rar
|
Degree to the horizontal and with an initial speed
: A player kicks a soccer ball towards the goalkeeper, but at an angle of 37 degree to the horizontal and with an initial speed of 14.7m/s The goalkeeper stands 26 m from the kicker. Where will the ball land relative to the goalkeeper?
|
|
Why is employee loyalty important to an organization today
: Choose a product or service you recently purchased. Tell how at least three marketing influences convinced you to purchase it or at lease helped you choose the brand or company. What is "buyer's remorse" and how can marketers overcome this behav..
|
|
Journal entry for the issuance of note by ontario resources
: Prepare the journal entry for the issuance of the note by Ontario Resources. Prepare the appropriate adjusting entry for the note by Ontario Resources on December 31, 2013. Show calculations.Prepare the journal entry for the payment of the note at ma..
|
|
Find the elapsed time for the journey
: If the girl has to run 48 m down the hill from where it first was pushed to get to where her sled stopped, find the elapsed time for the journey.
|
|
Estimates of the population standard deviation
: Find a point estimate of the population standard deviation. (Consider using the fillhandle here.) How do the 10 point estimates of the population mean compare to the actual population mean
|
|
What is difference in personnel involved and selling process
: According to our course materials and other sources, how is selling to a business different from selling to a consumer? What is the difference in personnel involved and the selling process? How might the sale of consumer products also be considere..
|
|
Compute amount and percentage changes for income statements
: Vision, Inc.'s comparative income statements follow. Compute the amount and percentage changes for the income statements, and comment on the changes from 2013 to 2014.
|
|
Complete multiple-step income statement for the company
: Prepare a complete multiple-step income statement for the company. (Hint: Rely on the amounts and percentages given to infer missing values.) (Round "Earnings per share" to 2 decimal places.)What is the gross profit percentage? (Enter your answer as ..
|
|
Unlimited life of company
: Unlimited life of company that continues in existence after original owners die or leave the company
|