I need an XY scatter graph using Microsoft Excel that has 30 for a maximum y axis and 4 for a maximum X axis. The numbers on the x-axis are offset with the numbers 0, 2, and 4 on the lines. The entire graph must have 36 individual cells. The graph needs to show all of the numbers 0-4, but only 0, 2, and 4 are directly on a li
The exercise problem the following information to figure prevalence and incidence rate: Population of the city of Atlantis on March 30th, 2003 = 183,000. Number of new cases of tuberculosis occurring between january 1st and June 30th, 1003 = 26 Number of active TB cases according to the city register on June 30th, 2003 =
1) What is the relationship between descriptive statistics and Affirmative Action ? 2) Can using probability in market trending decisions lead to a bad decision? Explain? 3) How do insurance companies use descriptive statistics and probability distributions to project health and auto insurance premiums? In regards to age,
Part I. T/F & Multiple Choice Questions Questions 1- 5 Answer True or False. 1. The field of statistics can be roughly subdivided into two areas: descriptive statistics and probability. ______ 2. A company employs 950 individuals. To ascertain how the employees feel regarding a pension plan, 105 of the emplo
Suppose X1,X2,...,X120 is an iid sample taken from a population with mean (mu)=20 and standard deviation (sigma) = 10. a) Can you find P(X1 > 22)? If so find it, if not state reason. b) Find P(X(bar) > 22)
The manager of a grocery store has taken a random sample of 100 customers. The average length of time it took the customers in the sample to check out was 3.1 minutes with a standard deviation of 0.5 minutes. We want to test to determine whether or not the mean waiting time of all customers is significantly more than 3 minutes
1. What types of sources of capital can be used in a transaction? Pick a single source of capital and describe why/under what circumstance you would use this type source.
A small firm builds television antennas. The investment in plan and equipment is $200,000. The variable cost per television antenna is $500. The price of the television antenna is $1000. How many television antennas would be needed for the firm to break even? 400 television antennae 600 television ante
There is a fixed cost of $50,000 to start a production process. Once the process has begun, the variable cost per unit is $25. The revenue per unit is projected to be $45. Find the break-even point. 2850 3000 2500 3500
1) How could you use descriptive statistics at work? 2) Describe the probability theory and how you can use it to increase your odds of winning at Blackjack? 3) How does the probability of absenteeism or longevity affect the hiring practices at your organization?
What is the difference between a mean and a proportion?
When planning the new baseball stadium for Washington DC, you are asked to find the break-even point for the number of luxury skyboxes built. The boxes are for sale to corporations and wealthy individuals for $100,000 each. The fixed cost for the entire upper deck is is $1,500,000 with a variable cost of $50,000 each per box.
The U.S. Army is about to award a contract for an electrical switching device to Integrated Switches Corporation (ICS) of Phoenix, Arizona. The switch will be used on the next version of infantry carrier vehicles. One obstacle that remains to be resolved, However, is that the Army requires a reliability of 0.995 for the device
See attached file for full problem description. The per capita personal income by state (including the District Columbia), in thousands of dollars, follows. 1. Organize these data into a frequency distribution. 2. What is a "typical" per capita income for a state? 3. How much variation in the income data is there? 4. Is
What are the main differences between descriptive and inferential statistics? Give examples of each. When would random sampling not be the best approach to sample selection? Give an example.
SS within samples is a sum of squares representing the variation that is assumed to be common to all the populations being considered. Is this true? Explain
Suppose that pulse rates among healthy adults are normally distributed with a mean of 81 beats/second and a standard deviation of 10 beats/second. What proportion of healthy adults have pulse rates that are more than 94 beats/sec? Round your answer to at least four decimal places.
1. Test the claim that the samples come from populations with the same mean. Assume that the populations are normally distributed with the same variance. Given the sample data below, test the claim that the populations have the same mean. Use a significance level of 0.05. Brand A Brand B Brand C n = 10 n = 10 n = 10 x-bar
1. A survey indicates that male employees were more likely than females to relocate without being promoted. What information would you want to know before you accepted the results of this survey? 2. At your place of employment, 100 employees are randomly selected and asked the distance of their commute to work. From this grou
Distribution and Variance. See attached file for full problem description.
1. The US Energy Information Administration reports figures on retail gasoline prices. Data are obtained by sampling 10,000 gasoline service stations from a total of more than 185000. For the 10,000 stations sampled in June 2003, the mean price per gallon for unleaded regular gasoline was $1.49. The mean price given here is a p
3. When John Zoidberg purchased the New New York City Dry Cleaners, he thought that because of its good location near several high-income neighborhoods, he would easily generate business if he improved the building's physical appearance. Therefore, he invested much his cash reserves in remodeling the exterior and interior of th
Histograms, graphs, basic statistics, T-tests, factorials. See attached file for full problem description.
Let's suppose that we have 2 variables year and age.. I use STATA to make them into dummy variables as follows: tabulate YEAR, generate(dum) tabulate AGE, gen (dum) Now, my question is....how can I make interactions for all of the dummy variables?
Create a Latin square design with 5-level factors
I am looking for the best simplified method for applying "Descriptive Statistics" to analysis of these 3 types of questions. This is not a statistics class but a portion of an assigned graduate level assignment. I need to determine the best statistical method to use and recommendations for graphing which will be inserted into th
A completely randomized (CRD) experiment was conducted in a glasshouse to test whether mature sugar beet roots are heavier when using a new fertilizer (A). Twenty pots of equal size were filled with the same compost and randomly placed on the bench in two parallel rows as shown below. To ten of pots the old fertilizer (B) was ad
6. A widely-used value function to represent the value of total assets to an individual is the natural logarithm of the assets; this means that the value of total assets of amount X is proportional to ln (X) (the natural logarithm of X). This value function is sometimes referred to in economics as the "decreasing marginal utili
You are assisting both Production departments in analyzing transportation capacity. Data has been collected on truck capacity (# of bags), truck weight, and truck age (in years) for the entire fleet. You have been asked to provide the major summary statistics for this information and you realize you will need to provide explanat
"Here we only look at one variable: the height of treated plant." Please clearly identify if this is a independent and dependent variable(s) that is being analyzed. And why there is only one variable?