Expert Answers

  (a) Write a function to compute and return the amount of money, A, that you will have in n years if you invest P dollars now at annual interest rate i. Take n, i, and P as parameters. The formula is   A = P(1 + i)n   (b) Write a function to compute and return the amount of money, P, that you would need to invest now at annual interest rate i in order to have A dollars in n years. Take n, i, and A as parameters. The formula is: P =A / (1 + i)n   (c) Write a function that will read and validate the inputs for this program. Using call by value/address, return an enumerated constant for the choice of formulas, a number of years, an interest rate, and an amount of money, in dollars. All three numbers must be greater than 0.0.   (d) Write a main program that will call the input routine to gather the data. Then, depending on the user's choice, it should call the appropriate calculation function and print the results of thecalculation.  

APA format (Times New Roman, size 12 and 2 space) MS Visio diagram OR MS Word Smart Art  Minimum 3 or more References including Sharda(Below) W5: Case Studies Graded Assignment:  Case Studies - (Follow all steps below) Carefully review and read both case studies found in your textbook from Pages 433 and 465-467 Sharda, R., Delen, D., & Turban, E. (2015) Business intelligence and analytics: Systems for decision support (10th ed.). Boston: Pearson. Digital: ISBN-13: 978-0-13-340193-6 or Print: ISBN-13: 978-0-13-305090-5 When concluding the paper, expand your analytical and critical thinking skills to develop ideas as a process or operation of steps visually represented in a flow diagram or any other type of created illustration to support your idea which can be used as a proposal to the entity or organization in the cases to correct or improve any case related issues addressed.  This is required for both cases. When developing illustrations to support a process or operation of steps, Microsoft Word has a tool known as “Smart Art” which is ideal for the development of these types of illustrations or diagrams.  To get acquainted with this tool, everyone can visit www.youtube.com using a keyword search “Microsoft Word Smart Art Tutorials” to find many video demonstrations in using this tool. QUESTIONS FOR THE END-OF-CHAPTER from Page# 433 APPLICATION CASE 1. What were the main challenges encountered by CARE International before they created their warehouse prepositioning model? 2. How does the objective function relate to the organization's need to improve relief services to affected areas? 3. Conduct online research and suggest at least three other applications or types of software that could handle the magnitude of variable and constraints CARE International used in their MIP model. 4. Elaborate on some benefits CARE International stands to gain from implementing their pre-positioning model on a large scale in future. QUESTIONS FOR THE END-OF-CHAPTER (Page NO#465-467) APPLICATION CASE  1. Describe the problem that a large company such as HP might face in offering many product lines and options. 2. Why is there a possible conflict between marketing and operations? 3. Summarize your understanding of the models and the algorithms. 4. Perform an online search to find more details of the algorithms. 5. Why would there be a need for such a system in an organization? 6. What benefits did HP derive from implementation of the models? Conclusion Reference info. Minimum 3 or more. 

Classic Gardens and Landscapes counts responses to specialty promotions to determine effectiveness. You use SUMIFS and an IFS formula to complete the summary. You also calculate insurance statistics and display full names in one cell. [Student Learning Outcomes 6.1, 6.2, 6.3, 6.6, 6.7] File Needed: ClassicGardens-06.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-ClassicGardens-06.xlsx Skills Covered in This Project Nest MATCH and INDEX functions. Create DSUM formulas. Build an IFS function. Build SUMIFS formulas. Use TEXTJOIN to join labels. Open the ClassicGardens-06 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Create a nested INDEX and MATCH function to display the number of responses from a city. Click the Mailings sheet tab and select and name cells A3:D28 as Responses. Click the Mailing Stats sheet tab. Click cell B21 and type Carthage. Click cell C21, start an INDEX function, and select the first argument list option. Choose or type the Responses range name for the Array argument. Click the Row_num box and nest a MATCH function. Select cell B21 for the Lookup_value and cells A3:A28 on the Mailings sheet for the Lookup_array. Click the Match_type argument box and type 0. Click INDEX in the Formula bar. Click the Column_num box and nest a second MATCH function to look up cell D3 on the Mailings sheet in the lookup array A3:D3. Click the Match_type box and type 0 (Figure 6-106) and click OK. The result displays as 343.00.Figure 6-106 Nested MATCH and INDEX functions Format the results to show zero decimal places. Type Smyrna in cell B21. Use DSUM to summarize mailing data. Select the Mailings sheet and note that number mailed is located in the third column and response data is in the fourth column. Click the Criteria sheet tab. Select cell B2 and type lan* to select data for the Landscape Design department. Type law* in cell B5 for the Lawn & Maintenance department. Type pat* in cell B8 for the Patio & Furniture department. Click the Mailing Stats sheet tab and select cell B7. Use DSUM with the range name Responses as the Database argument. Type 3 for the Field argument (# Mailed column), and enter an absolute reference to cells B1:B2 on the Criteria sheet as the Criteria argument. Copy the formula to cell C7 and edit the Field argument to use the fourth column (# Responses). Use DSUM in cells B8:C9 to calculate results for the two remaining departments. Use SUM in cells B10:C10. Format all values as Comma Style with no decimal places. Create an IFS function to display a response rating. Note: If your version of Excel does not include the IFS function, build the following nested IF function =IF(C7/B7>=20%,$C$15,IF(C7/B7>=15%,$C$16,IF(C7/B7>=11%,$C$17,$C$18))) to display the rating. Click cell D7. The response rate and ratings are shown in rows 14:18. Start an IFS function and select C7 for the Logical_test1 argument. Type / for division and select cell B7. Type >=20% to complete the test. Click the Value_if_true1 box, select C15, and press F4 (FN+F4) (Figure 6-107).Figure 6-107 First Logical_test and Value_if_true arguments Click the Logical_test2 box, select C7, type /, select cell B7, and type >=15%. Click the Value_if_true2 box, click cell C16, and press F4 (FN+F4). Complete the third and fourth logical tests and Value_if_true arguments (Figure 6-108).Figure 6-108 Completed IFS function arguments Copy the formula in cell D7 to cells D8:D10. Use SUMIFS to total insurance claims and dependents by city and department. Click the Employee Insurance sheet tab and select cell E25. Use SUMIFS with an absolute reference to cells F4:F23 as the Sum_range argument. The Criteria_range1 argument is an absolute reference to cells E4:E23. The Criteria1 argument is bre* to select the city of Brentwood. The Criteria_range2 argument is an absolute reference to cells D4:D23, the department column, with criteria of lan* to select the Landscape Design department. Click OK. The result for cell E25 is 10. Build SUMIFS formulas for cells E26:E28 based on the criteria displayed in cells C26:C28. Format borders to remove inconsistencies, if any, and adjust column widths to display data. Use TEXTJOIN to display names. Note: If your version of Excel does not include the TEXTJOIN function, use CONCAT or CONCATENATE to build the function. Click the Full Names sheet tab and select cell E4. Start a TEXTJOIN function and press Spacebar for the Delimiter argument. Click the Text1 box and select cell C4. Complete the Text2 and Text3 arguments to show middle and last names and click OK (Figure 6-109).Figure 6-109 Delimiter is a space Copy the formula to display full names in column E. Save and close the ClassicGardens-06 Excel workbook .

  Windows   Mac Boyd Air is monitoring flight arrival status as well as capacities. Before formatting the data as an Excel table, you will export it as a text file for use in the reservation software. You will filter the data in the table, build a PivotTable, and create a PivotChart. [Student Learning Outcomes 4.1, 4.2, 4.3, 4.4, 4.7, 4.8] File Needed: BoydAir-04.xlsx (Available from the Start File link.) Completed Project File Name: [your name]-BoydAir-04.xlsx Skills Covered in This Project Export data as a text file. Format data as an Excel table. Use a number filter in a table. Set conditional formatting with an icon set. Filter data by cell icon. Create and format a PivotTable. Create and format a PivotChart. Open the BoydAir-04.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Rename the sheet tab Stats. The worksheet includes the Boyd Air Flight Statistics. Select cell A4 and format the data as an Excel table using Green, Table Style Medium 21. Copy the Stats sheet to the end and name the copy PM Flights. Select the PM Flights sheet, and use a Greater Than filter to display flights with a departure time after 12:00 PM (Figure 4-106).Figure 4-106 Filter results for Departure Time field Select the Stats worksheet, select cells I5:I32, and set conditional formatting to use 3 Flags from the Icon Sets. Build a two-level Custom Sort for the Capacity column to sort by icon. Show the green flag at the top, followed by the yellow flag. The red flag will default to the bottom (Figure 4-107).Figure 4-107 Custom sort for the 3 Flags icon set Select the Stats worksheet, select cells A4:I32, and use the Quick Analysis tool to create a PivotTable to display average of capacity by origin (Figure 4-108).Figure 4-108 PivotTable suggestions from the Quick Analysis tool Rename the sheet PivotTable&Chart. Select cell B3 in the PivotTable and use Field Settings to set a Number Format of Percentage with two decimal places. Edit the Custom Name to display Average Capacity. Add the Passengers field to the PivotTable Values area with a sum calculation. Edit the field settings to display # of Passengers as the custom name. Set the number format to Number with zero decimals and a thousand’s separator. Use White, Pivot Style Light 8 for the PivotTable and show banded rows and columns. Add a 3-D Pie PivotChart to the sheet and position the chart object to start in cell E3. Size the chart to reach cell N22. Select the legend in the chart and change the font size to 11 from the Home tab. Show Data Labels on the chart positioned at the Inside End. Select a data label and format all labels from the Home tab as bold and 10 pt. Select cell A1 and save and close the workbook (Figure 4-109).Figure 4-109 Excel 4-5 completed Upload and save your project file.

(Implement a doubly linked list) The MyLinkedList class used in Listing 24.5 is a one-way directional linked list that enables one-way traversal of the list. Modify the Node class to add the new data field name previous to refer to the previous node in the list, as follows: public class Node { E element; Node next; Node previous; public Node(E e) { element = e; } } Implement a new class named TwoWayLinkedList that uses a doubly linked list to store elements. Define TwoWayLinkedList to implements MyList. You need to implement all the methods defined in MyLinkedList as well as the methods listIterator() and listIterator(int index). Both return an instance of java.util.ListIterator (see Figure 20.4). The former sets the cursor to the head of the list and the latter to the element at the specified index.

Open the StudentSuccess-03.docx start file. If the document opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Review and delete selected comments and tracked changes. Change the Display for Review view to All Markup. Read the comment at top of the document and then delete the comment. Find the first tracked change in the document (left, right, and top margin changed) and Reject Format Change. Review the changes in the document and then Accept All Changes and Stop Tracking. Apply styles to the title and headings. Apply the Title style to the title on the first page. Apply the Heading 1 style to all the bold headings Apply the Heading 2 style to all the underlined headings. Insert footnotes and apply text formatting. On the first page, insert a footnote after "Weekly Schedules" in the "Schedule Your Time" section. Type Weekly Schedules are available from your counselor or in the college bookstore. as the footnote text. Insert a footnote at the end of "Be sure to schedule your time for all these in your 119 hours." (after the period) in the "Schedule Your Time" section. Type Be sure to schedule recreational time in your 119 hours. as the footnote text. Move a footnote and modify footnote number format. Select the first footnote reference marker (in the body) and move it so it appears after “Weekly Schedule” in the “Track Your Time” section (use drag and drop or cut and paste). Deselect the moved footnote and change the footnote number format to a, b, c. Insert placeholders in the body of the document. In the “Introduction” section on the first page, insert a new placeholder named Navarro at the end of the body paragraph (and before the period). In the “Test Anxiety” section on the second page, insert a new placeholder named Sierra at the end of the body paragraph (and before the period). In the “Goal Setting” section on the fourth page, insert the Navarro placeholder (not a new placeholder) at the end of the intro paragraph (and before the period). Use the Source Manager dialog box to update placeholder reference information. Open the Source Manager and edit the Navarro placeholder to include the following information. Check the Show All Bibliography Fields box if necessary. Type of Source: Book Author: Tessa C. Navarro Title: Study Skills for College Students Year: 2018 City: Chicago Publisher: McGraw-Hill Edit the Sierra placeholder to include the following information. Type of Source: Document from Web site Corporate Author: Sierra Pacific Community College District Name of Web Page: Tips for Student Success Name of Web Site: spccd.edu Year: 2019 Year Accessed: 2020 Month Accessed: February Day Accessed: 2 URL: http://www.spccd.edu/tips4success.pdf Change bibliography style and insert a works cited page. Change the bibliography style to MLA. Place your insertion point on the blank line at the end of the document and insert a page break. Insert a Works Cited page. Insert a table of contents. Place your insertion point at the beginning of the document and insert a page break. Type Student Success Tips on the first line on the new first page (before the page break) and press Enter. On the blank line below "Student Success Tips," insert the Automatic Table 1 table of contents. Apply the Title style to “Student Success Tips” on the new first page. Insert a footer and add custom content. Edit the footer on the first page of the document (table of contents). Check the Different Odd & Even Pages box. The insertion point displays in the odd page footer. Insert the Accent Bar 2 from the Page Number, Current Position drop-down list. Press Tab two times and insert the Document Title (or Title) document property field. Go to the even page footer and insert the Accent Bar 2 from the Page Number, Current Position drop-down list. Press Tab two times and insert the Company document property field. Change the font size to 10 pt and apply bold formatting to all footer content in both the even and odd page footers. Close the footer. Insert and customize a cover page. Insert the Slice (Light) cover page. Delete the Subtitle (“Document subtitle”) and Course (“Course title”) document property fields. Change the font size of the title on the cover page to 40 pt and apply bold formatting. Insert a page break before the “Physical Signs of Test Anxiety” heading. Update the entire table of contents and save your document. Save and close the document (Figure 3-132). Upload and save your project file.

What are decision trees used for in a business setting? Why are they popular? Provide examples. Case Study 5.1 Read the Case Study:  Case 6.2 West Houser Paper Company (page # 289) from text book Write a summary analysis and determine if they used the correct tools to conduct the analysis.  Writing Requirements 3–4 pages in length  (excluding cover page, abstract, and reference list) Provide reference list and citations. APA format, Use the APA template located in the Student Resource Center to complete the assignment.. Lab 4 Complete the following in Chapter 6 Problems: #31 , #34  from textbook (Page #282, #283). Excel data has been attached below. Work on the problems and clearly explain answering the questions in word document. Provide the worked on excel files The assignment must be an APA formatted paper with embedded excel files

In order to complete the labs, you must install WAMP, the development server, and a PHP editor of choice, on your Windows computer. A.                Install the WAMP Development Server following steps in Appendix B. Install the PHP Editor Tools following steps in Appendix A   For the power users that want to step up from editing using Notepad, install one of these preferential PHP code editor:   ?    Microsoft Windows WordPad Editor (an optional improvement) ?    Microsoft Web Expressions 4.0 (the recommended improvement) ?    Microsoft Visual Studio Editor (an optional improvement) Complete Lab Work:   o   Discovery Project 1-1 (p.72) o   Discovery Project 1-2 (p.72) o   Discovery Project 1-3 (p.73) o   Discovery Project 1-4 (p.73)   2   ?  Save any coded PHP programs and scripts in the directory C:\wamp64\www\Wk2Exercise where you will ZIP and Submit the weeks PHP scripts and programs. ?  Submit the completed Exercises (Zip file of Wk2Excercise) directory to the dropbox under the Week1: Assignment submission area as an attachment. Reinforcement Exercises o   Exercise 4-1 (pages 221-224) o   Exercise 4-2 (pages 224-227) o   Exercise 4-3 (page 228) o   Exercise 4-4 (page 228) o   Exercise 4-5 (page 228)   o   Exercise 5-1 (pages 288-289) o   Exercise 5-2 (pages 289-291) o   Exercise 5-3 (page 291) o   Exercise 5-4 (page 291) o   Exercise 5-5 (pages 291-292)   o   Exercise 6-1 (pages 369-373) o   Exercise 6-2 (page 373) o   Exercise 6-3 (pages 373-376) o   Exercise 6-4 (page 376 o   Exercise 6-5 (page 376)  

 NO REFERENCES REQUIRED. NO MIN WORD COUNT. In this Assignment, you will demonstrate your understanding of the   data science methodology by applying it to a given problem. Pick one of the   following topics to apply the data science methodology to: 1. Emails 2. Hospitals 3. Credit Cards You will have to play the role of the client as well as the data   scientist to come up with a problem that is more specific but related to   these topics. Which topic did you choose to apply the data science methodology to? (2 marks) ............................ Next, you will play the role of the client and the data scientist. Using the topic that you selected, complete the Business Understanding stage by coming up with a problem that you would like to solve and phrasing it in the form of a question that you will use data to answer. (3 marks) You are required to: 1. Describe the problem, related to the topic you selected. 2. Phrase the problem as a question to be answered using data. For example, using the food recipes use case discussed in the labs, the question that we defined was, "Can we automatically determine the cuisine of a given dish based on its ingredients?". .............................. Briefly explain how you would complete each of the following stages for the problem that you described in the Business Understanding stage, so that you are ultimately able to answer the question that you came up with. (5 marks): 1. Analytic Approach 2. Data Requirements 3. Data Collection 4. Data Understanding and Preparation 5. Modeling and Evaluation You can always refer to the labs as a reference with describing how you would complete each stage for your problem. ....................................

The two social determinants that I have chosen are income and housing.   My first example is that the mortality rate for cardiovascular disease, all cancers combined, and diabetes is higher for those from lower educational levels and below the poverty line versus those who are above it. A 2015 National Health Survey says that those who make less than $35,000 a year are more likely to be diagnosed with the above-mentioned diseases than their counterparts. (National Library of Medicine)  My second example is housing: unstable housing, exposure to unsafe environments, and potential health hazards hurt health. These health hazards can vary from unsafe housing like potential lead poisoning to neighborhood hazards as violence, drugs, and unsanitary neighborhoods. (Medical News Today)  Aside from the initial Aids outbreak and the revolutions that had to go underway to gain some control of the spread of the illness, the two socioeconomic determinants I have chosen are a greater risk due to their continued growth in prevalence. As the divide between the middle class and the poor grows, the disadvantaged are at a higher and higher risk of contracting diseases.   I find the idea of Diffusion of Innovation Theory intriguing. Like our cell phones or the newest technology that everyone must have, things have a way of spreading like wildfire. New ideas, practices, and products have a way of spreading through a community. The theory goes on to describe the key players in diffusion which are innovators, early adopters, early majority, late majority, and laggards. (I’m a big fan of the use of marketing to distribute information that might not otherwise be seen or heard.) It is a way to get people excited and active in new policies or initiatives and can be used in public health objectives.   For example, a commercial for a new diabetic drug is airing during Nana’s favorite soap opera that she watches every single day. It is accompanied by a catchy tune that she can’t seem to shake. The next time she visited her physician, she asked about the new drug and if it would help her.   The best example of how marketing (DIT) can positively affect communities would be the use of commercials, radio, television, and internet advertising, to help inform people about the difference in vaccinations for Covid 19 from the very beginning of the epidemic. I know that I had questions for my physician about my choices of vaccinations and which would be best for me. My mother (who has MS) was prompted by all the ads to have in-depth conversations with her doctors about how she should take the initiative to protect herself in the best way possible during one of the most confusing times of my life.   References  GHEP Staff (2017). Social Determinants of Health in the United States: Addressing Major Health Inequality Trends for the Nation, 1935-2016  Social Determinants of Health in the United States: Addressing Major Health Inequality Trends for the Nation, 1935-2016 - PMC (nih.gov)Links to an external site.  Adam Bernstein MD ScD (2021). How Can Housing Influence Health, How can housing influence health? (medicalnewstoday.com)Links to an external site.  reply 2    My research into the complex interplay between many variables and health outcomes has led me to conclude that Americans' socioeconomic situation and their ability to obtain healthcare are two of the most important social determinants impacting their health. Not only do these factors affect people's health, but they also affect society as a whole. To start with, we may think about SES. Research has repeatedly highlighted its significant impact on health outcomes. In their research, Adler and Stewart (2010) shed light on the complex relationship between socioeconomic status (SES) and health inequalities. They explain how variables like income, education level, and employment interact to determine who has access to health promotion tools and opportunities. People from lower socioeconomic backgrounds often have difficulties obtaining enough healthcare, healthy food, stable housing, and excellent education, all of which contribute to their worse health (Adler & Stewart, 2010). Second, one of the most important factors is the availability of healthcare. Uneven access to healthcare, which disproportionately affects marginalized communities, persists despite the fact that medical technology has evolved in the US. When it comes to improving health outcomes and decreasing health inequalities, the CDC stresses the importance of healthcare access (CDC, 2020). Health disparities are worsened when people do not have easy access to medical care, which delays diagnosis, treatment, and preventative measures. Why, therefore, are these factors more consequential to society than infectious illnesses like HIV, COVID-19, or influenza? Addressing socioeconomic factors provides a more comprehensive and long-term solution to improve population health, even if infectious illnesses certainly present serious risks. The World Health Organization (WHO) highlights the need to tackle socioeconomic determinants in order to attain health equality. It is worth noting that these variables are fundamental to how people experience health and illness (WHO, 2020). We can alleviate the core causes of health inequalities and promote a healthier and more resilient society by addressing socioeconomic gaps and improving access to healthcare services. To sum up, if we want to make America a better place, we must learn about and do something about the social determinants of health. Giving priority to measures that address socioeconomic gaps and improve access to healthcare can result in a more equitable health environment where everyone has a chance to thrive. Instructor Guidance I'd want to study "access to health care services" since it affects community health. This hypothesis states that equal healthcare access improves community health. Healthcare access is crucial for reducing health inequities and improving well-being at the state and national levels. For instance, state-level healthcare access discrepancies might affect people's health. States with low healthcare resources may postpone preventive care, diagnosis, and treatment, leading to inferior health outcomes (Leiyu Shi & Stevens, 2010). Healthcare access gaps lead to national health disparities across demographic groupings. Due to geography, insurance, and culture, racial and ethnic minorities, low-income people, and rural communities typically have trouble getting healthcare (Smedley et al., 2003). Mobile health clinics address the social determinants of healthcare access in my community. Rural and urban areas without healthcare facilities get services from these clinics. Mobile health clinics provide preventative screenings, primary care, and health education to disadvantaged groups, improving healthcare access and outcomes (Arcury et al., 2012). For health equality and population health, healthcare access restrictions must be addressed. Mobile health clinics and extending healthcare coverage may help ensure that all people, regardless of socioeconomic class or geography, have equal access to healthcare. References: Adler, N. E., & Stewart, J. (2010). Health disparities across the lifespan: Meaning, methods, and mechanisms. Annals of the New York Academy of Sciences, 1186(1), 5-23. Centers for Disease Control and Prevention (CDC). (2020). Social determinants of health: Know what affects health. Retrieved from https://www.cdc.gov/socialdeterminants/index.htmLinks to an external site. World Health Organization (WHO). (2020). Social determinants of health. Retrieved from https://www.who.int/health-topics/social-determinants-of-health#tab=tab_1Links to an external site. Leiyu Shi & Stevens, G. D. (2010). Vulnerability and unmet health care needs. Journal of General Internal Medicine, 25(5), 453–458. Smedley, B. D., Stith, A. Y., & Nelson, A. R. (Eds.). (2003). Unequal treatment: confronting racial and ethnic disparities in health care. National Academies Press. Arcury, T. A., Gesler, W. M., Preisser, J. S., Sherman, J., Spencer, J., & Perin, J. (2012). The effects of geography and spatial behavior on health care utilization among the residents of a rural region. Health Services Research, 47(2), 814–830.