Description
What is the quotient of 56 and -2? ___
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
56/-2= -28
-28 is quotient
........................................................................
Completion Status:
100%
Review
Review
Anonymous
Just what I was looking for! Super helpful.
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
MATH 410 Colorado University Tractor Sales Quantitative Business Analysis Paper
International Tractor Motors (ITM) had recently undertaken an ad campaign aimed at agricultural owners in a certain countr ...
MATH 410 Colorado University Tractor Sales Quantitative Business Analysis Paper
International Tractor Motors (ITM) had recently undertaken an ad campaign aimed at agricultural owners in a certain country in Asia. The ad campaign was devoted to promoting the new IT-8 large specialty tractor. Four sales associates were assigned to sell in different medium to large farms throughout the country for many days. One associate was assigned to the northern part of the country. Another was assigned to the southern part. The other two were assigned to the west and east, respectively. Because of regulations, a sales associate can sell at most one IT-8 tractor per day and only one such tractor per farm, too. A sales associate was successful if he or she sold a tractor during the day. Thus, ITM can sell at most 4 tractors (4 total sales) per day in this country.
Download the file titled Tractor Successes. It contains a scatter plot of the number of successes versus frequency. To compare the results to the Binomial Distribution, complete the following:
Explain why this tractor sales scenario can be a binomial experiment.
Using the Tractor Successes scatter plot, construct a frequency distribution for the number of successes.
Compute the mean number of successes. The formula for the mean is as follows: ?(x?f)?f?(x?f)?f
The terms x represent the total number of successes (0, 1, 2, 3, 4) and f is the corresponding frequency (number of days where x successes occurred).
Explain what the numerical result means.
From the frequency distribution, construct the corresponding relative frequency distribution.
Explain why the relative frequency distribution table is a probability distribution.
Then, use Excel to create a scatter plot of the probability distribution:
Select the two columns of the probability distribution. Click on INSERT, and then go to the Charts area and select Scatter. Then choose the first Scatter chart (the one without lines connecting).
Using the frequency distribution, what is the tractor sales success average? In part 3, note that the numerator in the formula for the mean is the total number of successes. The total number of trials is the denominator of the formula for the mean multiplied by 4. What does this average mean?
The Binomial Distribution is uniquely determined by n, the number of trials, and p, the probability of "success" on each trial. Using Excel, construct the Binomial Probability Distribution for four trials, n, and probability of success, p, as the tractor sales success average in part 5. Here is an explanation of the BINOM.DIST function in Excel: https://support.office.com/en-ie/article/BINOM-DIST-function-c5ae37b6-f39c-4be2-94c2-509a1480770c?ui=en-USrs=en-IEad=I (Links to an external site.)
For example, In Excel
=BINOM.DIST(7,15,0.7, FALSE)
represents the probability of 7 successes out of 15 (n) trials. The 0.7 is the probability of success, p.
Using the above value of n=4 with probability of success, p, as the tractor sales success average in part 5, what is the probability of at least two successes?
Using the formula for the mean of the Binomial Distribution, what is the mean number of successes in part 6 above?
In Excel, create a scatter plot for the Binomial Distribution. The instructions for creating a scatter plot are in part 4 above.
Use the results above to compare the probability distribution of tractor sales successes and the Binomial Distribution. Compare the means in parts 4 and 6, too.
If the probability distribution of tractor sales successes and the Binomial Distribution differ, explain why that is so.
Do you think the Binomial Distribution is a good model for the tractor sales success scenario? Why or why not?
How can International Tractor Motors use the Binomial Distribution to approximate tractor sales in similar countries?
In what other scenarios can International Tractor Motors use the Binomial Distribution? Explain.
13 pages
Algebra 2 Part 2 Final Exam Nc
Directions: Answer the questions below. Make sure to show your work and justify all your 1. Bradley dropped a ball from a ...
Algebra 2 Part 2 Final Exam Nc
Directions: Answer the questions below. Make sure to show your work and justify all your 1. Bradley dropped a ball from a roof 16 feet high. Each time ...
PH 307 San Diego State University Hysterectomy Percentage of Women Worksheet
To complete this assignment, use the Excel file, “Data for Assignment 1,” posted on Blackboard in the Excel Assignment ...
PH 307 San Diego State University Hysterectomy Percentage of Women Worksheet
To complete this assignment, use the Excel file, “Data for Assignment 1,” posted on Blackboard in the Excel Assignment folder on the “Assignments” tab.It is preferred that students work in pairs on assignments, with one assignment submitted per pair; both students in a pair will receive the same grade. It is strongly recommended that both students actively participate in preparing the assignment. If, instead, partners choose to split the assignment (with each being responsible for different parts of the assignment), be aware than one person’s poor/non-completion of his/her portion is NOT an acceptable reason for submitting the assignment late. You may work with a student in the Monday section; if you do, please note that when you upload your assignment. (The Wednesday assignment is due before the Monday assignment; if you work with a Monday student, your assignment is still due on 9/23/2020.)At the completion of your assignment, you should have one workbook with four tabs (the original three tabs + one worksheet you have created). Name the file as follows: OurNamesAssign1.xlsx (or NamesAssign1.xls), where you replace OurNames with your first initials and last names. Your name(s) must be a part of your file name. Upload your completed Excel document to Blackboard on the assignment page.INSTRUCTIONS – READ CAREFULLY:When it is appropriate to show decimals, you should show 2 decimal places; use of decimal places should be consistent within a column (or variable). Use cell referencing in all formulas, and use functions that we have discussed in class whenever possible; a significant part of your grade is dependent on your use of appropriate cell referencing and use of functions.TIPS: Make it easy to locate all requested information. You can use bold or another font color or try using the paint can to fill the cell with color ( page1image3599999136) Use column/row titles to describe thedata included. Use column and row columns to describe the data included. To receive full credit, you will need to follow all instructions.Question 1 (27 points)
Using the Fourth Quarter 2019 California Hospital Quarterly Financial and Utilization data (thefirst tab in the “Data for Assignment 1”), copy the San Diego and Los Angeles County hospitalspage1image3600044112 page1image3600044400
1PH 307 Fall 2020to a new worksheet within this workbook. (Copy the rows holding the variable names and Los Angeles and San Diego County hospitals as described in class; do not copy the whole worksheet.) Name this tab “San Diego and Los Angeles.” Sort this worksheet by county. Remove any hospitals where the results of your calculations equal “#DIV/0!.” (To make the data easier to work with, I suggest that you hide columns that you will not need to answer the question.)Calculate the net inpatient revenue (est.) for each hospital located in San Diego County and Los Angeles County. (Hint: You will need to refer to the OSHPD documentation to determine how to calculate the net inpatient revenue.)
What are the mean and median net inpatient revenue (est.) for San Diego and Los Angeles Counties combined?
In a new column, use the appropriate function to recode the net inpatient revenue for each hospital as follows:
1) 0 if the net inpatient revenue is less than $25,000,000;
2) 1 if the net inpatient revenue is equal to or greater than $25,000,000.
Calculate the cost-to-charge ratio for each hospital located in San Diego County and Los Angeles County. (Refer to the OSHPD documentation to determine the correct formula.)
Set up this worksheet as follows:1) Include a header with your names and the date the assignment is due in the top right corner;2) Set the titles to repeat at top and the facility number and name to repeat at left; 3) Have the gridlines print.
Show only the facility number, facility name, county name, type_control, the columns used in the calculation, and the columns holding the information you calculated.
Question 2 (23 points)
The data on the “Hysterectomy” tab is a random sample of all hysterectomies performed in theUS in 1992.Using this data, create a frequency table and calculate relative frequency, cumulative frequency, and cumulative relative frequency for the age intervals 15-24, 25-34, 35-44, 45- 54, 55-64, 65-74, 75-84. To get credit on this question, you must use functions to calculate the frequencies; sorting the ages will not give you credit.
Calculate the mean age of hysterectomies.
page2image3584244096
2PH 307 Fall 2020 C. What is the percentage of women under the age of 35 who have had a hysterectomy?Please place parts B and C directly below the frequency table you have created.D. Set up this worksheet as follows:1) Portrait orientation;2) Include a header with your name and the date the assignment is due in the top right corner;3) Have the gridlines print.Question 3 (25 points)
You work as a data analyst for a health insurance company. Your firm is considering twoalternative plans for insuring employees of a company during the upcoming year.PlanA: Yourcompanywouldpay80%ofchargesforallservicesreceivedduringtheyearafter each employee pays a $650 annual deductible.Plan B: Your company would pay 75% of full charges, with no deductible or patient copayment.Last year’s claims by the employees of the company you are insuring are contained in the worksheet titled (Insurance Question) in the “Data for Assignment 1” workbook. There are three variables in this file: Total Charges = last year’s $ charges for medical services, Age = age of the individual, Sex = sex of the individual. You have been asked to analyze these plans to estimate next year’s payout under each alternative, using the assumption that charges will increase 8% next year over last year’s values.Please answer the following questions:Show each individual’s charges with the 8% increase.
Show each individual’s charges under Plan A.
Show each individual’s charges under Plan B.
What is the total payout under each alternative?
What is the total cost for females and for males under each of the plans?
What is the average cost per female and per male under each of the plans?
page3image3584554496
3PH 307 Fall 2020NOTE: Remember that your firm will pay nothing under Plan A for someone who incurs less than $650 in charges during the year (i.e., the employee’s charges do not exceed the $650 deductible).C. Set up this worksheet as follows:1) Landscape orientation;2) Include a header with your name and the date the assignment is due in the top right corner;3) Have the gridlines print.https://blackboard.sdsu.edu/bbcswebdav/pid-5803973... that's the dats let me know if u cant see that link
Apriori method using SPSS Modeler .
Details: The purpose of this assignment is to perform association rules analysis to determine whether or not the inform ...
Apriori method using SPSS Modeler .
Details: The purpose of this assignment is to perform association rules analysis to determine whether or not the information generated can be used to address a specific business problem. For this assignment, you will use the "Bakery" data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows. ReceiptID: Unique receipt ID (note that all items with the same receipt ID were purchased together) Item: Name of the food item that was purchased A bakery is interested in increasing sales by optimally displaying and arranging its various baked goods and drinks. The bakery would like to know which items are typically purchased together so it can place the correlated items closer together in its display cases. The bakery has randomly selected 1,000 receipts and compiled a list of items that were purchased together for each receipt. As an analyst, you have been asked to examine the data, summarize your findings, and recommend how the bakery can use these findings to strategically arrange its bakery products to increase sales. Use associative rules analysis to explore the various dependencies among purchased items. Use the Apriori method to do the analysis with a minimum antecedent support of 4%, minimum confidence of 70%, and maximum number of antecedents of 5. Analyze and interpret several of the resulting rules. Present your finding in the form of a 250-word executive summary that includes relevant data, charts, and tables, and addresses the following. Question 1: How would you explain the concepts of support, confidence, and lift to an executive who is unfamiliar with association rules analysis? Include the Apriori method output chart when submitting the answer. Question 2: What would you say about the support of the rules derived from the Apriori analysis? Question 3: If both an apple tart and an apple Danish were purchased, how likely is it that an apple croissant is also purchased? Explain your answer. Question 4: Does it make sense for the bakery to place all of its apple-flavored items together in the display or is it better to spread them out in the display? Explain why. Question 5: If the bakery wanted to increase the sales of cherry soda, what cross-promotional offers could it employ? Explain why. General Requirements: Submit the executive summary as Word document. APA format is not required, but solid academic writing is expected. This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to Turnitin. Rubric: Top of Form 1 Unsatisfactory 0.00% 2 Less than Satisfactory 65.00% 3 Satisfactory 75.00% 4 Good 85.00% 5 Excellent 100.00% 100.0 %Content 10.0 %Support, Confidence, and Lift Explanation of the concepts of support, confidence, and lift is not included. Explanation of the concepts of support, confidence, and lift is incomplete or incorrect. Explanation of the concepts of support, confidence, and lift is included but lack clarity. Explanation of the concepts of support, confidence, and lift is complete and accurate. Explanation of the concepts of support, confidence, and lift is expertly crafted. 20.0 %Support for Association Rules Discussion of support for the association rules derived from Apriori analysis is not included. Discussion of support for the association rules derived from Apriori analysis is incomplete or incorrect. Discussion of support for the association rules derived from Apriori analysis is included but lacks relevant supporting data and details. Discussion of support for the association rules derived from Apriori analysis is complete and includes relevant supporting data and details. Discussion of support for the association rules derived from Apriori analysis is expertly crafted and includes supporting data and substantial relevant details. 20.0 %Apriori Method Output Chart Apriori method output chart to support and communicate visual representations of data is not included. Apriori method output chart to support and communicate visual representations of data is incomplete or incorrect. Apriori method output chart to support and communicate visual representations of data is included and mostly correct. Apriori method output chart to support and communicate visual representations of data is complete and correct. Apriori method output chart to support and communicate visual representations of data is expertly crafted. 40.0 %Recommendations About Promotional Offers Recommendations about promotional offers that could be implemented based on the results of the association rules are not included. Recommendations about promotional offers that could be implemented based on the results of the association rules are incomplete or incorrect. Recommendations about promotional offers that could be implemented based on the results of the association rules are included but lack supporting data and explanation. Recommendations about promotional offers that could be implemented based on the results of the association rules are complete and include supporting data and explanation. Recommendations about promotional offers that could be implemented based on the results of the association rules are expertly crafted and supported with substantial data and explanation. 5.0 %Mechanics of Writing (includes spelling, punctuation, grammar, language use) Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed. Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech. Writer is clearly in command of standard, written, academic English. 5.0 %Paper Format (use of appropriate style for the major and assignment) Template is not used appropriately or documentation format is rarely followed correctly. Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent. Appropriate template is used. Formatting is correct, although some minor errors may be present. Appropriate template is fully used. There are virtually no errors in formatting style. All format elements are correct. 100 %Total Weightage Bottom of Form
Homework Statistics
ASAP homeworks for statistics............................................................................................. ...
Homework Statistics
ASAP homeworks for statistics.........................................................................................................................................................
3 pages
Correlation And Bivariate Regression 1
Effectiveness Correlates of School Leadership Styles and Teachers' Job Satisfaction: A The study's main objective was to c ...
Correlation And Bivariate Regression 1
Effectiveness Correlates of School Leadership Styles and Teachers' Job Satisfaction: A The study's main objective was to compare a leadership style ...
Similar Content
Need mathematics help with a perpendicular line
Find the gradient of a line perpendicular to 7y+5x=9...
Math assignment is very important please
Graded Assignment-8;04 SECOND PART.docx...
Keiser University Algebra Exponential Equation Rational Functions Questions
NOTE: You may submit a photo of your neat, hand-written work rather than a Word Document.
Find the vertex of the parab...
Please help with this question
Problem #36 Hypothesis Testing for Slope:Use the formula information. When testing the slope M of the regression line for ...
University of Alberta Maths Problem Solving and Reasoning Questions
Q1 Complete the following assignment after you have finished the M1LE1 Check Your
Understanding questions.
When you are fi...
ACC Mean Median and Mode Regression Estimates Basic Statistics Discussion
answer the following questions on the word documentation feel free to ask when it is not clear. i have to solve 7 question...
Related Tags
Book Guides
All the Kings Men
by Robert Penn Warren
The Adventures of Huckleberry Finn
by Mark Twain
The Two Towers
by J. R. R. Tolkien
Cat on a Hot Tin Roof
by Tennessee Williams
Bridge to Terabithia
by Katherine Paterson
Nervous Conditions
by Tsitsi Dangarembga
Fahrenheit 451
by Ray Bradbury
Where'd You Go Bernadette
by Maria Semple
Black Beauty
by Anna Sewell
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
MATH 410 Colorado University Tractor Sales Quantitative Business Analysis Paper
International Tractor Motors (ITM) had recently undertaken an ad campaign aimed at agricultural owners in a certain countr ...
MATH 410 Colorado University Tractor Sales Quantitative Business Analysis Paper
International Tractor Motors (ITM) had recently undertaken an ad campaign aimed at agricultural owners in a certain country in Asia. The ad campaign was devoted to promoting the new IT-8 large specialty tractor. Four sales associates were assigned to sell in different medium to large farms throughout the country for many days. One associate was assigned to the northern part of the country. Another was assigned to the southern part. The other two were assigned to the west and east, respectively. Because of regulations, a sales associate can sell at most one IT-8 tractor per day and only one such tractor per farm, too. A sales associate was successful if he or she sold a tractor during the day. Thus, ITM can sell at most 4 tractors (4 total sales) per day in this country.
Download the file titled Tractor Successes. It contains a scatter plot of the number of successes versus frequency. To compare the results to the Binomial Distribution, complete the following:
Explain why this tractor sales scenario can be a binomial experiment.
Using the Tractor Successes scatter plot, construct a frequency distribution for the number of successes.
Compute the mean number of successes. The formula for the mean is as follows: ?(x?f)?f?(x?f)?f
The terms x represent the total number of successes (0, 1, 2, 3, 4) and f is the corresponding frequency (number of days where x successes occurred).
Explain what the numerical result means.
From the frequency distribution, construct the corresponding relative frequency distribution.
Explain why the relative frequency distribution table is a probability distribution.
Then, use Excel to create a scatter plot of the probability distribution:
Select the two columns of the probability distribution. Click on INSERT, and then go to the Charts area and select Scatter. Then choose the first Scatter chart (the one without lines connecting).
Using the frequency distribution, what is the tractor sales success average? In part 3, note that the numerator in the formula for the mean is the total number of successes. The total number of trials is the denominator of the formula for the mean multiplied by 4. What does this average mean?
The Binomial Distribution is uniquely determined by n, the number of trials, and p, the probability of "success" on each trial. Using Excel, construct the Binomial Probability Distribution for four trials, n, and probability of success, p, as the tractor sales success average in part 5. Here is an explanation of the BINOM.DIST function in Excel: https://support.office.com/en-ie/article/BINOM-DIST-function-c5ae37b6-f39c-4be2-94c2-509a1480770c?ui=en-USrs=en-IEad=I (Links to an external site.)
For example, In Excel
=BINOM.DIST(7,15,0.7, FALSE)
represents the probability of 7 successes out of 15 (n) trials. The 0.7 is the probability of success, p.
Using the above value of n=4 with probability of success, p, as the tractor sales success average in part 5, what is the probability of at least two successes?
Using the formula for the mean of the Binomial Distribution, what is the mean number of successes in part 6 above?
In Excel, create a scatter plot for the Binomial Distribution. The instructions for creating a scatter plot are in part 4 above.
Use the results above to compare the probability distribution of tractor sales successes and the Binomial Distribution. Compare the means in parts 4 and 6, too.
If the probability distribution of tractor sales successes and the Binomial Distribution differ, explain why that is so.
Do you think the Binomial Distribution is a good model for the tractor sales success scenario? Why or why not?
How can International Tractor Motors use the Binomial Distribution to approximate tractor sales in similar countries?
In what other scenarios can International Tractor Motors use the Binomial Distribution? Explain.
13 pages
Algebra 2 Part 2 Final Exam Nc
Directions: Answer the questions below. Make sure to show your work and justify all your 1. Bradley dropped a ball from a ...
Algebra 2 Part 2 Final Exam Nc
Directions: Answer the questions below. Make sure to show your work and justify all your 1. Bradley dropped a ball from a roof 16 feet high. Each time ...
PH 307 San Diego State University Hysterectomy Percentage of Women Worksheet
To complete this assignment, use the Excel file, “Data for Assignment 1,” posted on Blackboard in the Excel Assignment ...
PH 307 San Diego State University Hysterectomy Percentage of Women Worksheet
To complete this assignment, use the Excel file, “Data for Assignment 1,” posted on Blackboard in the Excel Assignment folder on the “Assignments” tab.It is preferred that students work in pairs on assignments, with one assignment submitted per pair; both students in a pair will receive the same grade. It is strongly recommended that both students actively participate in preparing the assignment. If, instead, partners choose to split the assignment (with each being responsible for different parts of the assignment), be aware than one person’s poor/non-completion of his/her portion is NOT an acceptable reason for submitting the assignment late. You may work with a student in the Monday section; if you do, please note that when you upload your assignment. (The Wednesday assignment is due before the Monday assignment; if you work with a Monday student, your assignment is still due on 9/23/2020.)At the completion of your assignment, you should have one workbook with four tabs (the original three tabs + one worksheet you have created). Name the file as follows: OurNamesAssign1.xlsx (or NamesAssign1.xls), where you replace OurNames with your first initials and last names. Your name(s) must be a part of your file name. Upload your completed Excel document to Blackboard on the assignment page.INSTRUCTIONS – READ CAREFULLY:When it is appropriate to show decimals, you should show 2 decimal places; use of decimal places should be consistent within a column (or variable). Use cell referencing in all formulas, and use functions that we have discussed in class whenever possible; a significant part of your grade is dependent on your use of appropriate cell referencing and use of functions.TIPS: Make it easy to locate all requested information. You can use bold or another font color or try using the paint can to fill the cell with color ( page1image3599999136) Use column/row titles to describe thedata included. Use column and row columns to describe the data included. To receive full credit, you will need to follow all instructions.Question 1 (27 points)
Using the Fourth Quarter 2019 California Hospital Quarterly Financial and Utilization data (thefirst tab in the “Data for Assignment 1”), copy the San Diego and Los Angeles County hospitalspage1image3600044112 page1image3600044400
1PH 307 Fall 2020to a new worksheet within this workbook. (Copy the rows holding the variable names and Los Angeles and San Diego County hospitals as described in class; do not copy the whole worksheet.) Name this tab “San Diego and Los Angeles.” Sort this worksheet by county. Remove any hospitals where the results of your calculations equal “#DIV/0!.” (To make the data easier to work with, I suggest that you hide columns that you will not need to answer the question.)Calculate the net inpatient revenue (est.) for each hospital located in San Diego County and Los Angeles County. (Hint: You will need to refer to the OSHPD documentation to determine how to calculate the net inpatient revenue.)
What are the mean and median net inpatient revenue (est.) for San Diego and Los Angeles Counties combined?
In a new column, use the appropriate function to recode the net inpatient revenue for each hospital as follows:
1) 0 if the net inpatient revenue is less than $25,000,000;
2) 1 if the net inpatient revenue is equal to or greater than $25,000,000.
Calculate the cost-to-charge ratio for each hospital located in San Diego County and Los Angeles County. (Refer to the OSHPD documentation to determine the correct formula.)
Set up this worksheet as follows:1) Include a header with your names and the date the assignment is due in the top right corner;2) Set the titles to repeat at top and the facility number and name to repeat at left; 3) Have the gridlines print.
Show only the facility number, facility name, county name, type_control, the columns used in the calculation, and the columns holding the information you calculated.
Question 2 (23 points)
The data on the “Hysterectomy” tab is a random sample of all hysterectomies performed in theUS in 1992.Using this data, create a frequency table and calculate relative frequency, cumulative frequency, and cumulative relative frequency for the age intervals 15-24, 25-34, 35-44, 45- 54, 55-64, 65-74, 75-84. To get credit on this question, you must use functions to calculate the frequencies; sorting the ages will not give you credit.
Calculate the mean age of hysterectomies.
page2image3584244096
2PH 307 Fall 2020 C. What is the percentage of women under the age of 35 who have had a hysterectomy?Please place parts B and C directly below the frequency table you have created.D. Set up this worksheet as follows:1) Portrait orientation;2) Include a header with your name and the date the assignment is due in the top right corner;3) Have the gridlines print.Question 3 (25 points)
You work as a data analyst for a health insurance company. Your firm is considering twoalternative plans for insuring employees of a company during the upcoming year.PlanA: Yourcompanywouldpay80%ofchargesforallservicesreceivedduringtheyearafter each employee pays a $650 annual deductible.Plan B: Your company would pay 75% of full charges, with no deductible or patient copayment.Last year’s claims by the employees of the company you are insuring are contained in the worksheet titled (Insurance Question) in the “Data for Assignment 1” workbook. There are three variables in this file: Total Charges = last year’s $ charges for medical services, Age = age of the individual, Sex = sex of the individual. You have been asked to analyze these plans to estimate next year’s payout under each alternative, using the assumption that charges will increase 8% next year over last year’s values.Please answer the following questions:Show each individual’s charges with the 8% increase.
Show each individual’s charges under Plan A.
Show each individual’s charges under Plan B.
What is the total payout under each alternative?
What is the total cost for females and for males under each of the plans?
What is the average cost per female and per male under each of the plans?
page3image3584554496
3PH 307 Fall 2020NOTE: Remember that your firm will pay nothing under Plan A for someone who incurs less than $650 in charges during the year (i.e., the employee’s charges do not exceed the $650 deductible).C. Set up this worksheet as follows:1) Landscape orientation;2) Include a header with your name and the date the assignment is due in the top right corner;3) Have the gridlines print.https://blackboard.sdsu.edu/bbcswebdav/pid-5803973... that's the dats let me know if u cant see that link
Apriori method using SPSS Modeler .
Details: The purpose of this assignment is to perform association rules analysis to determine whether or not the inform ...
Apriori method using SPSS Modeler .
Details: The purpose of this assignment is to perform association rules analysis to determine whether or not the information generated can be used to address a specific business problem. For this assignment, you will use the "Bakery" data set from the Topic Materials. Most data categories are self-explanatory. Clarifying notes are as follows. ReceiptID: Unique receipt ID (note that all items with the same receipt ID were purchased together) Item: Name of the food item that was purchased A bakery is interested in increasing sales by optimally displaying and arranging its various baked goods and drinks. The bakery would like to know which items are typically purchased together so it can place the correlated items closer together in its display cases. The bakery has randomly selected 1,000 receipts and compiled a list of items that were purchased together for each receipt. As an analyst, you have been asked to examine the data, summarize your findings, and recommend how the bakery can use these findings to strategically arrange its bakery products to increase sales. Use associative rules analysis to explore the various dependencies among purchased items. Use the Apriori method to do the analysis with a minimum antecedent support of 4%, minimum confidence of 70%, and maximum number of antecedents of 5. Analyze and interpret several of the resulting rules. Present your finding in the form of a 250-word executive summary that includes relevant data, charts, and tables, and addresses the following. Question 1: How would you explain the concepts of support, confidence, and lift to an executive who is unfamiliar with association rules analysis? Include the Apriori method output chart when submitting the answer. Question 2: What would you say about the support of the rules derived from the Apriori analysis? Question 3: If both an apple tart and an apple Danish were purchased, how likely is it that an apple croissant is also purchased? Explain your answer. Question 4: Does it make sense for the bakery to place all of its apple-flavored items together in the display or is it better to spread them out in the display? Explain why. Question 5: If the bakery wanted to increase the sales of cherry soda, what cross-promotional offers could it employ? Explain why. General Requirements: Submit the executive summary as Word document. APA format is not required, but solid academic writing is expected. This assignment uses a grading rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion. You are not required to submit this assignment to Turnitin. Rubric: Top of Form 1 Unsatisfactory 0.00% 2 Less than Satisfactory 65.00% 3 Satisfactory 75.00% 4 Good 85.00% 5 Excellent 100.00% 100.0 %Content 10.0 %Support, Confidence, and Lift Explanation of the concepts of support, confidence, and lift is not included. Explanation of the concepts of support, confidence, and lift is incomplete or incorrect. Explanation of the concepts of support, confidence, and lift is included but lack clarity. Explanation of the concepts of support, confidence, and lift is complete and accurate. Explanation of the concepts of support, confidence, and lift is expertly crafted. 20.0 %Support for Association Rules Discussion of support for the association rules derived from Apriori analysis is not included. Discussion of support for the association rules derived from Apriori analysis is incomplete or incorrect. Discussion of support for the association rules derived from Apriori analysis is included but lacks relevant supporting data and details. Discussion of support for the association rules derived from Apriori analysis is complete and includes relevant supporting data and details. Discussion of support for the association rules derived from Apriori analysis is expertly crafted and includes supporting data and substantial relevant details. 20.0 %Apriori Method Output Chart Apriori method output chart to support and communicate visual representations of data is not included. Apriori method output chart to support and communicate visual representations of data is incomplete or incorrect. Apriori method output chart to support and communicate visual representations of data is included and mostly correct. Apriori method output chart to support and communicate visual representations of data is complete and correct. Apriori method output chart to support and communicate visual representations of data is expertly crafted. 40.0 %Recommendations About Promotional Offers Recommendations about promotional offers that could be implemented based on the results of the association rules are not included. Recommendations about promotional offers that could be implemented based on the results of the association rules are incomplete or incorrect. Recommendations about promotional offers that could be implemented based on the results of the association rules are included but lack supporting data and explanation. Recommendations about promotional offers that could be implemented based on the results of the association rules are complete and include supporting data and explanation. Recommendations about promotional offers that could be implemented based on the results of the association rules are expertly crafted and supported with substantial data and explanation. 5.0 %Mechanics of Writing (includes spelling, punctuation, grammar, language use) Surface errors are pervasive enough that they impede communication of meaning. Inappropriate word choice or sentence construction is used. Frequent and repetitive mechanical errors distract the reader. Inconsistencies in language choice (register) or word choice are present. Sentence structure is correct but not varied. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Correct and varied sentence structure and audience-appropriate language are employed. Prose is largely free of mechanical errors, although a few may be present. The writer uses a variety of effective sentence structures and figures of speech. Writer is clearly in command of standard, written, academic English. 5.0 %Paper Format (use of appropriate style for the major and assignment) Template is not used appropriately or documentation format is rarely followed correctly. Appropriate template is used, but some elements are missing or mistaken. A lack of control with formatting is apparent. Appropriate template is used. Formatting is correct, although some minor errors may be present. Appropriate template is fully used. There are virtually no errors in formatting style. All format elements are correct. 100 %Total Weightage Bottom of Form
Homework Statistics
ASAP homeworks for statistics............................................................................................. ...
Homework Statistics
ASAP homeworks for statistics.........................................................................................................................................................
3 pages
Correlation And Bivariate Regression 1
Effectiveness Correlates of School Leadership Styles and Teachers' Job Satisfaction: A The study's main objective was to c ...
Correlation And Bivariate Regression 1
Effectiveness Correlates of School Leadership Styles and Teachers' Job Satisfaction: A The study's main objective was to compare a leadership style ...
Earn money selling
your Study Documents