Question
In: Physics
Make Excel do all of the necessary calculations Report answers on the worksheet Label answers as...
- Make Excel do all of the necessary calculations
- Report answers on the worksheet
- Label answers as the questions are labelled: a, b, c,…
- Use the probability notation p(A), p(Aand B),… etc
- Submit your spreadsheet in Blackboard Assignment.
2. Due to recent global economic trends, Brazilian currency has lost value compared to the US dollar. This devaluation caused an increase in the price of products in Brazil. The following table summarizes results from a consumer survey that asked about the number of products being purchased and whether the brands purchased had changed (a trend towards purchasing less expensive brands was expected)
|
Number of Products Purchased |
||||
|
Brands purchased |
Fewer |
Same |
More |
Total |
|
Changed to less expensive |
262 |
82 |
8 |
352 |
|
Did not change |
10 |
14 |
24 |
48 |
|
Total |
272 |
96 |
32 |
400 |
What is the probability that a consumer selected at random:
a. purchased fewer products than before?
b. purchased fewer products and changed brands?
c. purchased fewer products or did not change brands?
d. Constance Aguero changed the brands she purchased. What is the probability that she purchased fewer number of products?
e. Robert Nanaim is purchasing fewer products. What is the probability that he has changed brands?
f. Are the events Brands purchased and Number of products purchased independent events? Show the test.
Solutions
genius_generous answered 1 year agoRelated Solutions
Make Excel do all calculations, using cell addresses. Don’t type numbers in your formulas. Report the...
Make Excel do all calculations, using cell addresses. Don’t type
numbers in your formulas.
Report the answers to the questions in your worksheet
using the appropriate symbols (µ σ) and notation p(x>=5),
p(X<3) etc...
Use Insert/Symbol to find mu and sigma for mean and std
dev.
x
P(x)
1. An auditor for Health Maintenance Services of Georgia reports
30 percent of policyholders 55 years or older submit a claim during
the year. Twelve policyholders are randomly selected for...
Make Excel do all calculations An insurance company has found that 10% of its claims are...
Make Excel do all calculations
An insurance company has found that 10% of its claims are for
damages resulting from burglaries. A random sample of 20 claims is
pulled.
a. What is the expected number(mean) that will be claimed for
damages resulting from burglaries?
b. What is the standard deviation?
Use Excel function BINOMDIST (watch podcast) as appropriate in
the following questions.
c. What is the probability that exactly 5 of the 20 will contain
claims that are for burglary...
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...
General guidelines:
Use EXCEL or PHStat to do the necessary computer work.
Do all the necessary analysis and hypothesis test constructions,
and explain completely.
Read the textbook Chapter 11. Solve the textbook example on page
403, "Mobile Electronics," in order to compare four different
in-store locations with respect to their average sales.
Use One-Way ANOVA to analyze the data set, data, given for this
homework.
Use 5% level of significance.
1) Do the Levene test in order to compare the...
General guidelines: Use EXCEL or PHStat to do the necessary computer work. Do all the necessary...
General guidelines:
Use EXCEL or PHStat to do the necessary computer work.
Do all the necessary analysis and hypothesis test constructions,
and explain completely.
Read the textbook Chapter 13. Imagine that you are managing a
mobile phone company. You want to construct a simple linear
regression model to capture and represent the relationship between
the number of customers and the annual sales level for a year with
95% confidence. You had conducted a pilot study for the past
fifteen years...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
A firm has 82 units of a product on hand. Forecasts of demand
are 30 units per week. An MPS quantity of 100 units is planned to
arrive in period 3. Customer orders are 32 for period 1, 28 for
period 2, and 25 for period 3. What is...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
The manager of QuikStop (open 365 days a year) sells 40 cases of
water each day. Order costs are $30 per order, and water costs
$0.10 per bottle (each case of water contains 24 bottles). Daily
holding costs are equal to 3 percent of the cost of the water....
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
Activity
Immediate
Predecessor
Activity Time
(wks)
Total Budgeted
Cost
A
-
4
24,000
B
-
5
15,000
C
A
2
16,000
D
B
8
40,000
E
C
3
30,000
F
D, E
5
55,000
G
F
3
21,000
H
D
7
21,000
I
F
5
10,000
J
G, H...
Please complete all work in excel. Use excel to make the calculations (cells can be clicked...
Please complete all work in excel. Use excel to make the
calculations (cells can be clicked on to view any formulas used)
and be sure to identify your answer, including units.
There are four jobs to be done and four employees to do them.
Each resource will take a specific time, translated to salaries, to
do each job, as shown in the following table:
Employee
Job
A
B
C
D
1
$20
23
21
17
2
18
18
22
19...
Generate and provide your answers to ALL questions using a Microsoft Excel Worksheet(s) and submit this...
Generate and provide your answers to ALL questions using a
Microsoft Excel Worksheet(s) and submit this Worksheet as a
separate document with your Word document file.
Note: You may answer this question in two or more Excel
Worksheets – one Worksheet containing the table and the other
Worksheet containing all the plots. Alternatively, you may choose
to provide each plot in a separate Worksheet.
Demonstrate how the spectral emissive power inside a blackbody
cavity changes with respect to the following...
Do a hypothesis for the following, make sure to include and label all five steps: ...
Do a hypothesis for the following, make sure to include
and label all five steps:
Test the claim that
the proportion of wins is the same whether the wear a
shirt
and tie or jeans and a t-shirt.
Use a .05 significance level.
Win
Loss
Suit and Tie
23
38
Jeans and T-shirt
28
24
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT