Reference no: EM131092587
1. A sample of 400 visitors to an exhibition was timed to determine how long each took to view the exhibit. Three samples were taken: one in the morning, the second in the afternoon and the third in the evening (use data set XR04-57 and Excel).
a. Determine the mean and the median of each sample.
b. Determine the range, the variance and the standard deviation of each sample.
c. Discuss the similarities and differences among samples.
d. Interpret your findings.
2. The set of data below is from a sample of n = 5
7, -5, -8, 7, 9
a. Calculate the mean, median, and mode
b. Calculate the range and interquartile range
c. Calculate the variance, standard deviation, and coefficient of variation
3. The Excel spreadsheet Investment.xls contains data on daily rate of returns (percentages) on three different investment options (A, B and C) over the past three years. Use these data to answer the following questions. When necessary use Excel's "Data Analysis" tool to generate graphs and statistics.
(a) Construct a histogram of the percentage returns for the data on Type A. (Note: Allow Excel to automatically select the number of ‘Bins' or classes. You may wish to reduce the number of decimal places in the ‘Bin' column of the output to 2 decimal places to keep the x axis tidy).
(b) In general, what do we mean if we say that a histogram is (i) symmetric, (iii) positively skewed, or (iii) negatively skewed?
(c) Would you describe the histogram for invest option A as symmetric, positively skewed or negatively skewed? Explain your answer.
(d) Use Excel to calculate the descriptive statistics for the percentage returns on investment Option A.
(e) Now use Excel to calculate the descriptive statistics for the percentage returns on investment options B and C given in the spreadsheet Investments.xls.
(f) Which investment option do you think has the highest expected returns? Use descriptive statistics to answer this question.
(g) Identify the investment option with the largest variation or ‘spread' in returns. Use available information to justify your answer.
(h) If you are an investor, who would like to invest in one of these options, which type of option you would rather invest in? Explain the reasoning behind your choice.
|
The latest forecast for the future
: Choose one financial topic (i.e., Stocks, Bonds, US Economy, Oil, China Economy, Interest Rates, Foreign Currencies, Japan Economy, Precious Metals, European Economy, etc.) and answer the following questions:
|
|
Formulate a linear programming model for b and b
: Formulate a linear programming model for B & B, that will help them estimate the number of meals they should prepare each night and solve this model by computer.
|
|
Find the leasing opportunities
: You work as a financial analyst for JR, Inc. Your company is considering the replacement of an old car with a new one. If you make any assumption in your analysis, please specify and explain it. You can Google "leasing a car" to find the leasing opp..
|
|
Return tradeoff: molly o''rourke stock purchase decision
: Over the past 10 years, Molly O'Rourke has slowly built a diversified portfolio of common stock. Currently her portfolio includes 20 different common stocks and has a total market value of 82,500.
|
|
Calculate the range and interquartile range
: Calculate the range and interquartile range - calculate the variance, standard deviation, and coefficient of variation
|
|
Other consumer goods open stores in outlet malls
: Many manufacturers of clothing and other consumer goods open stores in outlet malls where they charge much lower prices than they charge in their own stores located within cities. Outlet malls are typically located a considerable distance from major ..
|
|
Develop innovative training programs
: Conclude with recommendations for optimizing cooperation between health care organizations based on the course readings and your experience.
|
|
Perform a critical assessment for adoption of nuclear power
: Perform a critical assessment for, and adoption or rejection of, nuclear power or coal-fired power generation as part of your power generation options
|
|
Differences between the lead user process
: Create a table that shows the differences between the Lead User process and traditional marketresearch methods. Attach this in your post.
|