Description
What is the slope of each line?
| Line A: |
| Line B: |
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Thank you for the opportunity to help you with your question!
Though the question does not appear complete, I will help you know how to find the slope of a line.
For any line, you will get the change in y-axis divided that in x-axis to get the gradient, thus the slope of that line.
With this, the problem is solved.
But for what you have presented here, both the slopes of A and B are at zero gradients.
Completion Status:
100%
Review
Review
Anonymous
Super useful! Studypool never disappoints.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
systems of linear inequalities
Which of the following systems of inequalities has no solution?o y < 0 x >/= 0o 3x - 4y < ...
systems of linear inequalities
Which of the following systems of inequalities has no solution?o y < 0 x >/= 0o 3x - 4y < 1 3x - 4y < 8o 4x + y > 4 8x + 2y < -5o 3x - y > 1 6x - 2y < 20Which system of inequalities is best represented by the graph?yo_graph.jpgo y </= 2x + 2 y > -x - 1o y >/= 2x + 2 y < -x - 1o y < 2x + 2 y </= -x - 1o y > 2x + 2 y </= -x - 1Which system of inequalities is best represented by the graph?o y < x y >/= x - 3o y > x y </= x - 3o y </= x y > x - 3o y >/= x y < x - 3Which graph shows the solution to the system of inequalities?y ≤ x + 9y ≥ -x - 4o o o o Which system of inequalities is graphed below?o x + y > -5 -2x + y >/= 3o x + y > -5 -2x + y < 3o x + y > -5 -2x + y </= 3o x + y > -5 -2x + y > 3Which graph shows the solution to the system of inequalities shown below? o o o o Which of the following systems of inequalities has its solution shown on the graph below?o o o o Which graph shows the solution to the system of inequalities below?o o o o Which ordered pair is in the solution region of the system of inequalities below?o (0, 0)o (3, -1)o (1, 1)o (2, 1)Which ordered pair is in the solution region of the system of inequalities below? o (2, -2)o (6, 3)o (2, 0)o (2, 4)
MTH 156 Colorado State University Global Campus Module 3 Springdale Shopping Survey Essay
Option #1: Springdale Shopping Survey
Instructions
The major shopping areas in the community of Springdale include Springd ...
MTH 156 Colorado State University Global Campus Module 3 Springdale Shopping Survey Essay
Option #1: Springdale Shopping Survey
Instructions
The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to provide information about themselves and their shopping habits. The data are provided in the file SHOPPING. The variables in the survey can be found in the file CODING.
The contingency tables and relative frequency probabilities in this exercise are based on the Springdale Shopping Survey database. Information like that gained from the two parts of this exercise could provide helpful insights into the nature of the respondents, their perceptions, and their spending behaviors. In particular, part 2 focuses on how conditional probabilities related to spending behavior might vary, depending on the gender of the respondent.
NOTE: Be sure to use five (5) decimal places for your probabilities in the report, as some of them will be quite small. Do not convert to percentages as we are interested in probabilities only here.
Based on the relative frequencies for responses to each variable, determine the probability that a randomly selected respondent from:
SPRSPEND [variable 4] spends at least $15 during a trip to Springdale Mall.
DOWSPEND [variable 5] spends at least $15 during a trip to Downtown.
WESSPEND [variable 6] spends at least $15 during a trip to West Mall.
Comparing the preceding probabilities, rank the areas from strongest to weakest in terms of the amount of money a shopper spends during a typical shopping visit.
Based on the relative frequencies for responses to each variable, determine the probability that a randomly selected respondent from:
BSTQUALI [variable 11] feels that Springdale Mall has the highest-quality goods.
BSTQUALI [variable 11] feels that Downtown has the highest-quality goods.
BSTQUALI [variable 11] feels that West Mall has the highest-quality goods.
Comparing the preceding probabilities, rank the areas from strongest to weakest in terms of the quality of goods offered.
Set up a contingency table for the appropriate variables given, and then determine the following probabilities:
SPRSPEND and RESPGEND [variables 4 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to Springdale Mall? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
DOWSPEND and RESPGEND [variables 5 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to Downtown? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
WESSPEND and RESPGEND [variables 6 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to West Mall? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
Based on the preceding probabilities, rank the shopping areas where males and females are most likely to least likely to spend $15 or more during a shopping visit.
Requirements:
Your paper should be 2-3 pages in length (not counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library is a great place to find resources. Your textbook is a credible resource.
Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic.
The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables or graphs.)
Document formatting, citations, and style should conform to CSU Global Writing Center. (Links to an external site.) A short summary containing much that you need to know about paper formatting, citations, and references is contained in the Template Paper (Links to an external site.).
Option #2: Probabilities of Graduation and Publication
Instructions
In the following study, three different universities have been tracking a select group of professors over the course of their employment at that university to determine the number of students who are in a particular professor’s classes, how many of those students have graduated, and if any of them have had their work published. The attached Excel file Probabilities are the totals for each of the professors at the three different universities that participated in the study.
The purpose of this study is to find the probabilities of graduation and publication for the students in the different professors’ courses. While a causal relationship may not be found between a professor and student graduation or publication, we need to rank the professors based on the different probabilities found using the data sets as described below.
Prepare a report (see below) with your ranking of the professors based on the probabilities and conditional probabilities as well as the analysis of each university. Include the following seven (7) items in table format which is provided in the Probabilities file to support your ranking.
NOTE: Be sure to retain and report five (5) decimal places for each of your probabilities. Do not convert your computed probabilities to percentages, as we are only interested in probabilities here.
The overall probability of students graduating at each of the three universities.
The overall probability of students having a publication at each of the three universities.
The overall probability of students having a publication, given that they graduated at each of the three universities.
The probability of a student graduating for each professor.
The probability of a student having a publication for each professor.
The probability of a student having a publication, given that they graduated for each professor.
Rank the professors within each university for each of the probabilities in 4-6. Then find the sum of the ranks and determine an overall ranking for each professor.
Be sure to critically analyze the above calculations in your body paragraphs, explaining how you found each type of probability and then the results that you obtained. Be sure to also explain your criteria for ranking in steps 4-7, being sure to defend why you chose that particular ranking method, as your way might not be the typical method.
GB 513 UOPX Unit 6 Real World Situations Business Analytics PPT & Excel Sheet
In this assignment, you will be assessed based on the following outcomes: GB513-4: Evaluate real-world situations and pres ...
GB 513 UOPX Unit 6 Real World Situations Business Analytics PPT & Excel Sheet
In this assignment, you will be assessed based on the following outcomes: GB513-4: Evaluate real-world situations and present solutions using statistical methods. PC-6.1: Incorporate data, inferences, and reasoning to solve problems. This assignment has two parts. Part 1 has questions about forecasting, you will submit your answers to part 1 using the Unit 6 Assignment template (see attached). You still need to submit the Excel file you used to generate your answers, in addition to the report in Word. Part 2, requires you to analyze a case, you will prepare a PowerPoint presentation to present your findings. See further instructions below under “Part 2-Case Analysis” for more details.Part 1 – Forecasting Answer the following three questions using the template provided. Question 1 A store managers wishes to forecast the weekly number of television sets sold. Calculate the error for each of the following forecasts, the MAD and the MSE. Be sure to show the entire table in the work area of the template. Period Value Forecast Error 1202 — — 2191 202 3173 192 4169 181 5171 174 6175 172 7182 174 8196 179 9204 189 10 219 198 11 227 211 Question 2 The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts for years 6 through 13 using a 5-year moving average. Then, calculate forecasts for years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Be sure to show the entire table in the work area of the template.Answer the following questions: a)What is the forecast for year 13 based on the 5-year moving average? b)What is the forecast for year 13 based on the 5-year weighted moving average? c)What is the MAD for the moving average forecast?d)What is the MAD for the weighted moving average forecast? Which forecasting model that you calculated is better? Why?What is the average rating for all CBC movies? How about ABN movies and BBS movies? Comment how the networks are performing, using the metrics in the table. Your analysis should extend beyond simply comparing the average ratings for each network. What are the null and alternative hypotheses (state in full sentences)? What is your recommendation to the executives? Justify your answer referring to the relevant figures. Which dependent variable contributes more when determining a movie’s rating: Being fact-based or having one star? How much does each of these factors change the ratings? How well does this regression analysis explain the ratings? Justify your answers referring to the relevant figures. Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures. Year Factory orders 1 2,512.70 2 2,739.20 3 2,874.90 4 2,934.10 5 2,865.70 6 2,978.50 7 3,092.40 8 3,052.60 9 3,145.20 10 3,114.10 11 3,257.40 12 3,654.00 13 Question 3 The “Economic Report to the President of the United States” included data on the amounts of manufacturers’ new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 21-year period. Use the charting tool in Excel to develop a regression model to fit the trend effects for the data. Use a linear model and then try a polynomial (order 2) model. Make sure the charts show the line formula and the r-squared value. Include both charts in your report. Then, answer the following question: ● How well does either model fit the data? Which model should be used for forecasting? Explain using the relevant metrics. Year Total Number of New Orders1 55,022 2 55,921 3 64,182 4 76,003 5 87,327 6 85,139 7 99,513 8 115,109 9 116,251 10 121,547 11 123,321 12 141,200 13 162,140 14 168,420 15 171,250 16 176,355 17 195,204 18 209,389 19 237,025 20 272,544 21 293,475 Part 2 – Case Analysis To answer Part 2, you will prepare a PowerPoint presentation to present your findings. Make sure you also submit the Excel file to show your work for Part 2. You will receive a 100 point reduction if you fail to include the Excel file showing your work for Part 2. Place all calculations for each of the questions on a separate worksheet. Then, using the results of your work from Excel, prepare PowerPoint slides to answer the questions in a presentation format. All relevant content should be on the slides; do not use the notes section or leave information in the Excel file. The executives reviewing the presentation should not need to switch to another document to see the required information. The data you need is provided to you in the Unit 6 Excel file in Course Documents. Make sure to use that file. Do not type anything in manually or download anything from the Internet. You will be analyzing the “Colonial Broadcasting” case in the course pack that you bought at the beginning of the course. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore everything in the case document after the end of page 4. The executives at CBC want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months. They also want to know if hiring stars makes a difference and the impact of fact-based programming compared to hiring stars. Remember that your audience is the management of CBC. Therefore, make sure your presentation is professional and provides sufficient explanation. 1.Answer the following questions: b.Include a table that shows the average and the other descriptive statistics (using the data analysis tool pack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table. 2.Create a line graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months; you will need to calculate an average for each month first, and then plot the averages. After you create the graph, fit a linear trend line, displaying the formula and the r-squared. Explain to the executives if you can use this time series data to forecast the ratings of upcoming months. How accurate can you expect this forecast to be? 3.Should the CBC hire stars for their movies? To answer this question, run a hypothesis test to see if there is a significant difference between the ratings of movies with stars versus movies without stars. Use the data for CBC movies only. Use 95% confidence. Answer the following: b.Run the test using Excel and include the output table. Use a t-test assuming equal variances. 4.Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions: Directions for Submitting your Assignment: Be sure to complete the Unit 6 Assignment template. Submit your assignment to the Unit 6 AssignmentDropbox. Unit 6 Assignment ContentPoints Possible Points Earned Part 1 - Forecasting Question 1 Provided the MAD. 5 Question 1 Provided the MSE. 5 Question 2a Correct forecast for year 13 using a 5-year moving average. 5 Question 2b Correct forecast for year 13 using a 5-year weighted moving average. 5 Question 2c Correct MAD for moving average forecast. 5 Question 2d Correct MAD for weighted moving average forecast. 5 Question 2e Recommended the better model with justification. 5 Question 3 Used Excel charting to fit a linear trendline, including the formula and r-squared. 5 Question 3 Used Excel charting to fit a polynomial trendline, including the formula and r-squared. 5 Question 3 Recommended the better model with justification. 5 Part 2 – Case Analysis Question 1 Correct average rating for all three networks. 10 Question 1 Correct table showing the average and other descriptive statistics for the ratings of the three networks, using one column for each network. 10 Question 1 Appropriate explanation and analysis of what is learned from each of the metrics in the descriptive statistics table. 20 Question 2 Correct line graph using the calculated average monthly ratings of CBC for the year, showing r-squared and the formula. 20 Question 2 Summary to executives regarding whether the linear forecast can be used to project ratings, including an assessment of how accurate the forecast can be expected to be. 20 Question 3 Correct null and alternative hypotheses stated in full sentences. 20 Question 3 Accurate hypothesis test results. 20 Question 3 Correct recommendation and justification for whether CBC should hire stars. 20 Question 4 Correct figures and explanation of how much contribution each independent variable makes when determining a movie’s rating: 20 Question 4 Correct figures and explanation of how well this regression analysis explains the ratings. 20 Question 4 Correct figures, accurate identification and justification of which variables are significantly related to ratings. 20 PowerPoint is formatted appropriately and communicated clearly. 50 Total300
Linear Regression
Using the attached data ("Car Weight and MPG.sav"), compute and interpret the relationship between:Car Weight (“Weight� ...
Linear Regression
Using the attached data ("Car Weight and MPG.sav"), compute and interpret the relationship between:Car Weight (“Weight”) and miles per gallon consumed (“CityMPG”)For this regression analysis, state the following:A clear research question appropriate for a linear regression: (e.g., Is X a significant predictor of Y?")Null and research hypotheses that align clearly and neatly with your RQ.Description of the variables used.Your dependent and independent variables. (Clearly explain your rationale as to why which is which.)State the sample size, along with the mean, standard deviation, and range (min & max) for each variable, in a paragraph format. (Do not just include a table, and not talk about it.)State the rationale for applying regression analysis in this investigation using appropriate readings and resources in Module 5. (Please cite specific references.)Findings in an APA format. (This includes the wording of the finding and the tables/figures included.)Use the following link to provide the template: https://www.slideshare.net/plummer48/reporting-a-single-linear-regression-in-apaAlso add a clear interpretation of the R-square value in your finding. See last page: https://www.sheffield.ac.uk/polopoly_fs/1.531434!/file/MASH_simple_linear_regression_SPSS.pdfNote: Even if the p-value in the SPSS output shows ".000," write it out as "p < .001."Write out your regression equation, and state the predicted miles per gallon for cars that weighs 3,000 and 4,000 pounds. (Clearly show the calculations and steps involved.)Include the SPSS output in your appendix.Car Weight and MPG.sav
1 page
Cable Case.. 1
Question 1a: What do you see as the management decision problem? Question 2a: Overall how satisfied are respondents with t ...
Cable Case.. 1
Question 1a: What do you see as the management decision problem? Question 2a: Overall how satisfied are respondents with the cable service overall ...
Similar Content
Etale Cohomology: Resources
I need some resources to learn the basics of this type of cohomology. I would prefer to have someone with a lot of experie...
algebra homework help
x+y=91x-y=11now x=?,y=?...
MATH 171 Ohio State University Calculus Question
...
STATS 202 University of Southern California Linear Regression Worksheet
Lecture 3: Linear Regression
STATS 202: Data Mining and Analysis
Linh Tran
tranlm@stanford.edu
Department of Statistics
...
8.1 9 Please solve this. Thanks!
...
Differential Equations Worksheet
T
Prob 1 (Total of 30 pts): Consider the IVP for u(x,t) that is 2m periodic in z:
Ut=urr,t>0,-...
Trig Pythagorean
Can trigonometry be used to prove the Pythagorean Theorem? Please provide an explanation and The Greek mathematician Pytha...
1 Or 16
1 is correct, but 16 is also correct, the result is ambiguous, depending on what you´re trying to This ambiguity is what ...
Q3
Well, the false statement is the FIRST: three lines CAN intersect in one point. Indeed, take arbitrary point and draw any ...
Related Tags
Book Guides
The President is Missing
by James Patterson, Bill Clinton
Nervous Conditions
by Tsitsi Dangarembga
Daisy Miller
by Henry James
The Russian Hoax
by Gregg Jarrett
And Then There Were None
by Agatha Christie
Beowulf
by Anonymous Anglo-Saxon poet
The Nightingale
by Kristin Hannah
Sounds Like Titanic
by Jessica Chiccehito Hindman
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
systems of linear inequalities
Which of the following systems of inequalities has no solution?o y < 0 x >/= 0o 3x - 4y < ...
systems of linear inequalities
Which of the following systems of inequalities has no solution?o y < 0 x >/= 0o 3x - 4y < 1 3x - 4y < 8o 4x + y > 4 8x + 2y < -5o 3x - y > 1 6x - 2y < 20Which system of inequalities is best represented by the graph?yo_graph.jpgo y </= 2x + 2 y > -x - 1o y >/= 2x + 2 y < -x - 1o y < 2x + 2 y </= -x - 1o y > 2x + 2 y </= -x - 1Which system of inequalities is best represented by the graph?o y < x y >/= x - 3o y > x y </= x - 3o y </= x y > x - 3o y >/= x y < x - 3Which graph shows the solution to the system of inequalities?y ≤ x + 9y ≥ -x - 4o o o o Which system of inequalities is graphed below?o x + y > -5 -2x + y >/= 3o x + y > -5 -2x + y < 3o x + y > -5 -2x + y </= 3o x + y > -5 -2x + y > 3Which graph shows the solution to the system of inequalities shown below? o o o o Which of the following systems of inequalities has its solution shown on the graph below?o o o o Which graph shows the solution to the system of inequalities below?o o o o Which ordered pair is in the solution region of the system of inequalities below?o (0, 0)o (3, -1)o (1, 1)o (2, 1)Which ordered pair is in the solution region of the system of inequalities below? o (2, -2)o (6, 3)o (2, 0)o (2, 4)
MTH 156 Colorado State University Global Campus Module 3 Springdale Shopping Survey Essay
Option #1: Springdale Shopping Survey
Instructions
The major shopping areas in the community of Springdale include Springd ...
MTH 156 Colorado State University Global Campus Module 3 Springdale Shopping Survey Essay
Option #1: Springdale Shopping Survey
Instructions
The major shopping areas in the community of Springdale include Springdale Mall, West Mall, and the downtown area on Main Street. A telephone survey has been conducted to identify strengths and weaknesses of these areas and to find out how they fit into the shopping activities of local residents. The 150 respondents were also asked to provide information about themselves and their shopping habits. The data are provided in the file SHOPPING. The variables in the survey can be found in the file CODING.
The contingency tables and relative frequency probabilities in this exercise are based on the Springdale Shopping Survey database. Information like that gained from the two parts of this exercise could provide helpful insights into the nature of the respondents, their perceptions, and their spending behaviors. In particular, part 2 focuses on how conditional probabilities related to spending behavior might vary, depending on the gender of the respondent.
NOTE: Be sure to use five (5) decimal places for your probabilities in the report, as some of them will be quite small. Do not convert to percentages as we are interested in probabilities only here.
Based on the relative frequencies for responses to each variable, determine the probability that a randomly selected respondent from:
SPRSPEND [variable 4] spends at least $15 during a trip to Springdale Mall.
DOWSPEND [variable 5] spends at least $15 during a trip to Downtown.
WESSPEND [variable 6] spends at least $15 during a trip to West Mall.
Comparing the preceding probabilities, rank the areas from strongest to weakest in terms of the amount of money a shopper spends during a typical shopping visit.
Based on the relative frequencies for responses to each variable, determine the probability that a randomly selected respondent from:
BSTQUALI [variable 11] feels that Springdale Mall has the highest-quality goods.
BSTQUALI [variable 11] feels that Downtown has the highest-quality goods.
BSTQUALI [variable 11] feels that West Mall has the highest-quality goods.
Comparing the preceding probabilities, rank the areas from strongest to weakest in terms of the quality of goods offered.
Set up a contingency table for the appropriate variables given, and then determine the following probabilities:
SPRSPEND and RESPGEND [variables 4 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to Springdale Mall? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
DOWSPEND and RESPGEND [variables 5 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to Downtown? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
WESSPEND and RESPGEND [variables 6 and 26] Given that the random respondent is a female, what is the probability that she spends at least $15 during a trip to West Mall? Is a male more likely or less likely than a female to spend at least $15 during a visit to this area?
Based on the preceding probabilities, rank the shopping areas where males and females are most likely to least likely to spend $15 or more during a shopping visit.
Requirements:
Your paper should be 2-3 pages in length (not counting the title page and references page) and cite and integrate at least one credible outside source. The CSU Global Library is a great place to find resources. Your textbook is a credible resource.
Include a title page, introduction, body, conclusion, and a reference page.
The introduction should describe or summarize the topic or problem. It might discuss the general applications of the topic or it might introduce the unique terminology associated with the topic.
The body of your paper should address the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.
The conclusion should summarize your thoughts about what you have determined from your analysis in completing the assignment. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.
Include any tables of data or calculations, calculated values, and/or graphs referenced in the paper. (Note: The minimum required length excludes any tables or graphs.)
Document formatting, citations, and style should conform to CSU Global Writing Center. (Links to an external site.) A short summary containing much that you need to know about paper formatting, citations, and references is contained in the Template Paper (Links to an external site.).
Option #2: Probabilities of Graduation and Publication
Instructions
In the following study, three different universities have been tracking a select group of professors over the course of their employment at that university to determine the number of students who are in a particular professor’s classes, how many of those students have graduated, and if any of them have had their work published. The attached Excel file Probabilities are the totals for each of the professors at the three different universities that participated in the study.
The purpose of this study is to find the probabilities of graduation and publication for the students in the different professors’ courses. While a causal relationship may not be found between a professor and student graduation or publication, we need to rank the professors based on the different probabilities found using the data sets as described below.
Prepare a report (see below) with your ranking of the professors based on the probabilities and conditional probabilities as well as the analysis of each university. Include the following seven (7) items in table format which is provided in the Probabilities file to support your ranking.
NOTE: Be sure to retain and report five (5) decimal places for each of your probabilities. Do not convert your computed probabilities to percentages, as we are only interested in probabilities here.
The overall probability of students graduating at each of the three universities.
The overall probability of students having a publication at each of the three universities.
The overall probability of students having a publication, given that they graduated at each of the three universities.
The probability of a student graduating for each professor.
The probability of a student having a publication for each professor.
The probability of a student having a publication, given that they graduated for each professor.
Rank the professors within each university for each of the probabilities in 4-6. Then find the sum of the ranks and determine an overall ranking for each professor.
Be sure to critically analyze the above calculations in your body paragraphs, explaining how you found each type of probability and then the results that you obtained. Be sure to also explain your criteria for ranking in steps 4-7, being sure to defend why you chose that particular ranking method, as your way might not be the typical method.
GB 513 UOPX Unit 6 Real World Situations Business Analytics PPT & Excel Sheet
In this assignment, you will be assessed based on the following outcomes: GB513-4: Evaluate real-world situations and pres ...
GB 513 UOPX Unit 6 Real World Situations Business Analytics PPT & Excel Sheet
In this assignment, you will be assessed based on the following outcomes: GB513-4: Evaluate real-world situations and present solutions using statistical methods. PC-6.1: Incorporate data, inferences, and reasoning to solve problems. This assignment has two parts. Part 1 has questions about forecasting, you will submit your answers to part 1 using the Unit 6 Assignment template (see attached). You still need to submit the Excel file you used to generate your answers, in addition to the report in Word. Part 2, requires you to analyze a case, you will prepare a PowerPoint presentation to present your findings. See further instructions below under “Part 2-Case Analysis” for more details.Part 1 – Forecasting Answer the following three questions using the template provided. Question 1 A store managers wishes to forecast the weekly number of television sets sold. Calculate the error for each of the following forecasts, the MAD and the MSE. Be sure to show the entire table in the work area of the template. Period Value Forecast Error 1202 — — 2191 202 3173 192 4169 181 5171 174 6175 172 7182 174 8196 179 9204 189 10 219 198 11 227 211 Question 2 The data below shows the number of goods manufactured in one year. ($ billion). Calculate forecasts for years 6 through 13 using a 5-year moving average. Then, calculate forecasts for years 6 through 13 using a 5-year weighted moving average. Weight the most recent year by 6, the previous year by 4, the year before that by 2, and the other years by 1. Be sure to show the entire table in the work area of the template.Answer the following questions: a)What is the forecast for year 13 based on the 5-year moving average? b)What is the forecast for year 13 based on the 5-year weighted moving average? c)What is the MAD for the moving average forecast?d)What is the MAD for the weighted moving average forecast? Which forecasting model that you calculated is better? Why?What is the average rating for all CBC movies? How about ABN movies and BBS movies? Comment how the networks are performing, using the metrics in the table. Your analysis should extend beyond simply comparing the average ratings for each network. What are the null and alternative hypotheses (state in full sentences)? What is your recommendation to the executives? Justify your answer referring to the relevant figures. Which dependent variable contributes more when determining a movie’s rating: Being fact-based or having one star? How much does each of these factors change the ratings? How well does this regression analysis explain the ratings? Justify your answers referring to the relevant figures. Are either, both, or neither of the independent variables significantly related to the ratings at 95% confidence? Justify your answers referring to the relevant figures. Year Factory orders 1 2,512.70 2 2,739.20 3 2,874.90 4 2,934.10 5 2,865.70 6 2,978.50 7 3,092.40 8 3,052.60 9 3,145.20 10 3,114.10 11 3,257.40 12 3,654.00 13 Question 3 The “Economic Report to the President of the United States” included data on the amounts of manufacturers’ new and unfilled orders in millions of dollars. Shown here are the figures for new orders over a 21-year period. Use the charting tool in Excel to develop a regression model to fit the trend effects for the data. Use a linear model and then try a polynomial (order 2) model. Make sure the charts show the line formula and the r-squared value. Include both charts in your report. Then, answer the following question: ● How well does either model fit the data? Which model should be used for forecasting? Explain using the relevant metrics. Year Total Number of New Orders1 55,022 2 55,921 3 64,182 4 76,003 5 87,327 6 85,139 7 99,513 8 115,109 9 116,251 10 121,547 11 123,321 12 141,200 13 162,140 14 168,420 15 171,250 16 176,355 17 195,204 18 209,389 19 237,025 20 272,544 21 293,475 Part 2 – Case Analysis To answer Part 2, you will prepare a PowerPoint presentation to present your findings. Make sure you also submit the Excel file to show your work for Part 2. You will receive a 100 point reduction if you fail to include the Excel file showing your work for Part 2. Place all calculations for each of the questions on a separate worksheet. Then, using the results of your work from Excel, prepare PowerPoint slides to answer the questions in a presentation format. All relevant content should be on the slides; do not use the notes section or leave information in the Excel file. The executives reviewing the presentation should not need to switch to another document to see the required information. The data you need is provided to you in the Unit 6 Excel file in Course Documents. Make sure to use that file. Do not type anything in manually or download anything from the Internet. You will be analyzing the “Colonial Broadcasting” case in the course pack that you bought at the beginning of the course. Begin by reading the description in the case. Then, answer the questions listed below, NOT the questions listed in the case. Ignore everything in the case document after the end of page 4. The executives at CBC want to see how they are doing in ratings against the other networks and how the ratings will continue to change in the upcoming months. They also want to know if hiring stars makes a difference and the impact of fact-based programming compared to hiring stars. Remember that your audience is the management of CBC. Therefore, make sure your presentation is professional and provides sufficient explanation. 1.Answer the following questions: b.Include a table that shows the average and the other descriptive statistics (using the data analysis tool pack in Excel) for the ratings of the three networks (one column for each network). Explain what you learn from each of the metrics in the table. 2.Create a line graph of the monthly average ratings for CBC for the year. Note that there are multiple ratings data for the months; you will need to calculate an average for each month first, and then plot the averages. After you create the graph, fit a linear trend line, displaying the formula and the r-squared. Explain to the executives if you can use this time series data to forecast the ratings of upcoming months. How accurate can you expect this forecast to be? 3.Should the CBC hire stars for their movies? To answer this question, run a hypothesis test to see if there is a significant difference between the ratings of movies with stars versus movies without stars. Use the data for CBC movies only. Use 95% confidence. Answer the following: b.Run the test using Excel and include the output table. Use a t-test assuming equal variances. 4.Run a multiple regression where the dependent variable is ratings and the independent variables are star and fact. Use data from CBC only. CBC Management has several questions: Directions for Submitting your Assignment: Be sure to complete the Unit 6 Assignment template. Submit your assignment to the Unit 6 AssignmentDropbox. Unit 6 Assignment ContentPoints Possible Points Earned Part 1 - Forecasting Question 1 Provided the MAD. 5 Question 1 Provided the MSE. 5 Question 2a Correct forecast for year 13 using a 5-year moving average. 5 Question 2b Correct forecast for year 13 using a 5-year weighted moving average. 5 Question 2c Correct MAD for moving average forecast. 5 Question 2d Correct MAD for weighted moving average forecast. 5 Question 2e Recommended the better model with justification. 5 Question 3 Used Excel charting to fit a linear trendline, including the formula and r-squared. 5 Question 3 Used Excel charting to fit a polynomial trendline, including the formula and r-squared. 5 Question 3 Recommended the better model with justification. 5 Part 2 – Case Analysis Question 1 Correct average rating for all three networks. 10 Question 1 Correct table showing the average and other descriptive statistics for the ratings of the three networks, using one column for each network. 10 Question 1 Appropriate explanation and analysis of what is learned from each of the metrics in the descriptive statistics table. 20 Question 2 Correct line graph using the calculated average monthly ratings of CBC for the year, showing r-squared and the formula. 20 Question 2 Summary to executives regarding whether the linear forecast can be used to project ratings, including an assessment of how accurate the forecast can be expected to be. 20 Question 3 Correct null and alternative hypotheses stated in full sentences. 20 Question 3 Accurate hypothesis test results. 20 Question 3 Correct recommendation and justification for whether CBC should hire stars. 20 Question 4 Correct figures and explanation of how much contribution each independent variable makes when determining a movie’s rating: 20 Question 4 Correct figures and explanation of how well this regression analysis explains the ratings. 20 Question 4 Correct figures, accurate identification and justification of which variables are significantly related to ratings. 20 PowerPoint is formatted appropriately and communicated clearly. 50 Total300
Linear Regression
Using the attached data ("Car Weight and MPG.sav"), compute and interpret the relationship between:Car Weight (“Weight� ...
Linear Regression
Using the attached data ("Car Weight and MPG.sav"), compute and interpret the relationship between:Car Weight (“Weight”) and miles per gallon consumed (“CityMPG”)For this regression analysis, state the following:A clear research question appropriate for a linear regression: (e.g., Is X a significant predictor of Y?")Null and research hypotheses that align clearly and neatly with your RQ.Description of the variables used.Your dependent and independent variables. (Clearly explain your rationale as to why which is which.)State the sample size, along with the mean, standard deviation, and range (min & max) for each variable, in a paragraph format. (Do not just include a table, and not talk about it.)State the rationale for applying regression analysis in this investigation using appropriate readings and resources in Module 5. (Please cite specific references.)Findings in an APA format. (This includes the wording of the finding and the tables/figures included.)Use the following link to provide the template: https://www.slideshare.net/plummer48/reporting-a-single-linear-regression-in-apaAlso add a clear interpretation of the R-square value in your finding. See last page: https://www.sheffield.ac.uk/polopoly_fs/1.531434!/file/MASH_simple_linear_regression_SPSS.pdfNote: Even if the p-value in the SPSS output shows ".000," write it out as "p < .001."Write out your regression equation, and state the predicted miles per gallon for cars that weighs 3,000 and 4,000 pounds. (Clearly show the calculations and steps involved.)Include the SPSS output in your appendix.Car Weight and MPG.sav
1 page
Cable Case.. 1
Question 1a: What do you see as the management decision problem? Question 2a: Overall how satisfied are respondents with t ...
Cable Case.. 1
Question 1a: What do you see as the management decision problem? Question 2a: Overall how satisfied are respondents with the cable service overall ...
Earn money selling
your Study Documents
