Category: Data Engineering

HW#3 is to analyze the data you actually obtained and organize the analysis results using the Bass model or Logistic growth model. (The data subject to analysis here is data that the individual believes is suitable for the diffusion model/growth model, such as domestic products and services. (Republic of Korea))
You can use a program for analysis that you are comfortable with.
To submit, please compress the data file (excel), program code used for analysis, and report (pdf) into a zip file and submit.
explain the results with tables and graphs
The report must be detailed and explanatory, report length is 7 pages (8400 words), 11 point size. and the similarity should be max 2%. Assignments with more than 2% similarities will be excluded from direct scoring.

Below are the tables and the corresponding values that are supposed to be inserted and manipulated as required and mentioned below:
Need to insert or delete values or manipulate the data in such a way that it returns some values without giving us NULL results.
The ask is to provide the query or series of queries that we are required to run in order to get some data which satisfies each of the below questions. Also provide manipulated tables if we need to create any new column as such we need that as well.
Question:
Implement Oracle SQL code to solve the queries listed below. Additionally, you have to design and solve 10 additional SQL queries, 6 update and 6 delete statements for your project. List the total number of hotels without swimming pool facilities located in California.
Find hotel locations with the lowest reservations on November 23, 2023.
Find the name of the employee(s) assigned to hotels in Dallas that had worked the most hours on November 3, 2023.
List the hotels that have at least 20 rooms but with less than 10 employees working in their location.
Print the payroll from March 4, 2022 to March 10, 2022 displaying employee name, hours worked and total salary for all employees
Design a delete statement to delete employees without graduate degrees. in hotels located outside the United States.
Design an update statement to give a 23% salary raise to employees working more than 5 hours from March 4, 2023 to March 10, 2023.
Please find the attachment for the table schema and input data.

There r two parts of this assignment Part one is due TODAY by 12 PM there is 1 week for the second part. Major OR FIELD: Mechanical engineering Part 1: All NEEDED DOCUMENTS R ATTACHED IN ORDER
Assignment Description After the completion of the 3 elements of the IDL 2 assignment series, you will have developed a memorandum for executives in an assigned fictitious company for which you work. This memorandum will make the case for all new hires to be required to be proficient in probability and statistics, also known as data literate because of its importance to your business. The purpose of this assignment element is to get to read and interpret the statistics you will use for this assignment. Additionally, you will think about how to speak to an executive audience.
Assignment Elements: IDL Workshop 3 – Assignment IDL 2 expectation introduction
IDL 2 Preliminary part 1 (due one hour before workshop 4) IDL 2 Preliminary part 2 (due one hour before workshop 4, no late assignments will be accepted.) IDL Workshop 4 Data review and memorandum discussion
IDL 2 Final Memorandum (the problem detail is included in this assignment.)
Required Reading
The following reading will provide you with input you need to successfully complete this assignment. Executives Download Executivesby House, Layton, Livingston & Moseley from The Engineering Communication Manual. This brief chapter introduces how to effectively communicate with Executives.
Professional Tone Download Professional Tone by Dr. Gobes-Ryan. This document presents guidelines for professional writing to assist you in developing appropriate professional tone for communicating with executives. Data Source- Analytics and AI-driven enterprises thrive in the age of with: The culture catalystLinks to an external site. by Tim Smith, Ben Stiller, Jim Guszcza, and Tom Davenport from Deloitte Insights. This document contains the data you will use as evidence for your argument that your division will be more profitable if employees are proficient in statistics and probability. Review the assignment template Download assignment templateprior to reading this. (It is a document that Deloitte makes publicly available.) Assignment Elements Element 1: Preparation Complete Data Literacy: An Introduction to Finding and Evaluating Data Completing this part of the IDL 2 preliminary work will provide background for completing this work successfully.
Element 2: Download and Review Assignment
Download the attached IDL 2 preliminary assignment template Download IDL 2 preliminary assignment templateand review what you will need to complete. Element 3: Review the Assigned Data Document and Complete Template
Review Analytics and AI-driven enterprises thrive in the age of with: The culture catalystLinks to an external site. keeping in mind what you need to identify from it for the assignment. As you will be using data from the text, graphs, and charts, you may find it helpful to highlight the information that you believe is important. Complete the provided template. For answers that require more than one or two words or numbers, you must use your own words. The last element of the assignment will require you to have read Executives Download Executives and Professional ToneDownload Professional Tone
Upload the assignment completed using the provided template AND bring a copy with you to the workshop. During the workshop you will share what you found in small teams, where you will help each other hone your thinking on what the relevant statistics are, tell you, and utility for making the argument you will make for the final phase of IDL 2. Assignment Deliverable, Due Date, Questions, and Submittal Deliverable: Use the provided assignment template Download assignment templatefor your assignment. No quotations and no plagiarism will be allowed in this assignment – Quotations are rarely used in professional engineering and computer science writing; do not get in the habit of doing this. Ethically completed work must have at its core your own thinking built upon credible knowledge of experts that proceeded you. Also unacceptable is: Using the words of others without quotation marks and in-text citations Using the words of others, but reorganizing the sentence structure (This is a form of plagiarism called inappropriate paraphrasing.) Using the words of others, but changing a few words in each sentence (This is a form of plagiarism called inappropriate paraphrasing.) The words in your document must represent your own thinking, based on the information you have gathered. Citing credible sources from which you got ideas gives you credibility and it is required in this work. If you want to be sure you are clear on what constitutes plagiarism review the USF Avoiding Plagiarism page.Links to an external site. AI Use: You are expected to use AI to check the grammar, punctuation and spelling on this work and for no other purposes. No late assignments will be accepted after Workshop 4 as the assignment will be reviewed during the workshop. Submittal: All assignments MUST be uploaded to Canvas as a Word document or a PDF. After submitting your assignment check to see that it uploaded and that the document you uploaded is your completed assignment. Incorrectly submitted work resubmittals will only be accepted for 5 days, and will be penalized 20% of your earned grade per day. Assignments provided by Canvas message or by email are not considered submitted as they are not in the correct location for grading.
PART 2:
Assignment Description
After the completion of the 3 elements of the IDL 2 assignment series, you will have developed a memorandum for executives in an assigned fictitious company for which you work. This memorandum will make the case for all new hires to be required to be proficient in probability and statistics, also known as data literate because of its importance to your business. In this assignment you will compose and revise the memorandum demonstrating appropriate tone and scope needed to communicate with executives. You will also demonstrate an ability to make an argument using statistics. Reading Required
Word Choices for precision and accuracy – introductory nontechnical levelLinks to an external site. – on The Civil Engineering Writing Project website, Materials for Courses & Independent Study page. Effective Sentence Structure – Simple SentencesLinks to an external site. – on The Civil Engineering Writing Project website, Materials for Courses & Independent Study page. Additional resources to assist you in successful completion of this assignment are included throughout this assignment. Problem Statement
You are working for Rishe Solutions Incorporated, a 14,000 person consulting organization. You work in a 600-person division of the organization that provides client services in your field. That is, all the types of professional work products your field produces are marketed to Rishe clients as consulting services. Your manager has asked you to write a memorandum to be provided to your division leaders. This memorandum will make a case that increasing the number of employees in the division proficient in statistics and probability will make the division more profitable. The profitability will emerge from improving provided services’ quality and improving division effectiveness and efficiency. You will recommend that this be accomplished by making data literacy a requirement for all new hires. The leaders she has asked you to address the memorandum to are Verena Bonet, Vice President of [your field]; Amara Nwafor, Associate Vice President of [your field]; and Elliott Richdale, Human Resources Director for [your field]. You will also copy it to your manager, Dianne Reeves. You are to assume that these leaders are senior professionals in your field with the knowledge that entails. Specifically, Ms. Reeves is requesting that the division require and verify probability and statistics proficiency for all new hires in the division. She has tasked you with accomplishing this policy change request by:
Highlighting how statistics and probability are used in the services your division provides to clients. To support your argument, this part of the document will summarize aspects of the services your division provides in which statistics and probability are applied and for what purpose each is used. Note: In this section, I expect you to use the research you did for assignment IDL 1. However, as you are writing to a different audience for a different purpose, you will use it differently. If you feel your research from IDL 1 is inadequate for this assignment, you may add additional sources.
Documenting the importance to division success of having all employees engaged in data analytics (analyzing data using probability and statistics for increased profitability and meeting division goals). For this part of the work, she is providing you with a document summarizing external research data provided by a Rishe partner, Deloitte, to support this case. She wants you to review this data for: Relevance: Is the data Deloitte collected relevant to Rishe? Are the participants from whom Deloitte collected the data similar enough to Rishe to suggest their findings would be applicable to Rishe? You will include what the data indicates, the source of the data provided, the size and reliability of the study, and how that data source aligns or not with Rishe as an organization. How does it support the claim you are making? How the data provided can support your argument that more data literate/probability and statistics proficient employees will make the division more profitable. After reviewing the data, you will use them to make the case that your division will be more profitable if more employees are able to engage in data analytics (that is applying probability and statistics knowledge.) You will recommend that the organization accomplish this by making data literacy a requirement for all new hires in the division. Please note: In the future, some of you will work in organizations with coworkers with diverse professional skills, all making a specific contribution to producing a product. This assignment is NOT structured for that type of organization. For example, you will not present this as an engineer working in a manufacturing facility. You will not present this as a cybersecurity expert working within a financial institution. Assignment Elements 1. Download Template for Use
To complete this assignment, you must use this memorandum template Download memorandum template. IDL 2 Example Download IDL 2 Exampleshows how the document should be structured. However, the example is not on the same topic, or using the same document for statistics, so you cannot copy the content.
2. Draft Memorandum Your document will have the following elements (download a copy of the document structure Download document structure) : Memorandum Header. TO and CC – The ‘To” and “CC” lines content are provided on the template
Complete the “From” and “Date” lines to resemble the format of the examples. The “Re” (regarding) line specifically and concisely says what your memorandum is about. A reader should know from reading the title precisely what it will be about but they will not get details from this line. Introduction. As with any professional document, the beginning of the document needs to provide readers with an overview of why it is important to them, what it will address, and how. Structure the elements as follows: Why This Document is Important – Start business documents with a statement of the larger business objective that everyone reading the memorandum will agree with. Describe the big-picture business objective that motivates the purpose of this document. After writing this statement, you need a sentence or two to connect that idea to the thesis. Thesis/Purpose – A clear statement of what the document is about and what you want the readers to do/know/believe after reading it. Show your thesis statement in BOLD FONT in your final document.
Preview – the preview identifies what the document’s body will discuss to support the thesis. This element succinctly names the body elements, often aligning with section titles. Always present this information in the same order as the body elements.
Probability and Statistics Use in [Your Field] Division Services. Using the understanding of probability and statistics in your field you developed in assignment IDL 1, revise your communication of this material to support the arguments you are making to executives. To assist you with this, remember the roles of executives within the organization as described in your reading. Be sure you explain these in terms of their priorities. In-text citations are required in this section. Topic introduction – This introduction connects this section’s topic to the thesis. Then, identify what you will present on that topic in the order you will communicate it.
Describe elements – Develop ideas that emerge from the topic introduction and logically move from one idea to the next. Use a bullet point approach for this document element, as shown in the example. In this section you will describe uses of probability and statistics in your field at a level appropriate to remind executives about their use. Remember these executives have advanced knowledge of your field.
Summary Statement – end with a concluding statement summarizing what you found or documented.
The Importance of Probability and Statistics Literacy for Our Division’s Operational Success. In this section, you will present your argument as a cohesive well-written case. You will incorporate the data from Analytics and AI-driven enterprises thrive in the age of with: The culture catalystLinks to an external site. as evidence. At least one in-text citation is required in this section. Topic Introduction – In this introduction connect this section’s topic to the thesis. Then identify what you will present on that topic in the order you will communicate it.
Describe Elements – Develop ideas that emerge from the topic introduction and logically move from one idea to the next. The elements included are:Data and Source Validation – Describe the reliability of the statistics source and the quality of the statistics used for this review. Address how these statistics are like what you are analyzing and why they are worth looking at for your situation.
Argument Using Statistics – Describe what the statistics support relative to the thesis. Include only statistics pertinent to your argument. Include the numbers in context to the scale they are on.
Summary Statement – End with a summary of what insight this body element provides.
Conclusion. In this section, reverse the order of your introduction content, maintain your meaning but use different words. Be sure to end with a statement of what you accomplished and how by providing this memorandum. Review – The review describes what the document’s body discussed in support of the thesis. This statement succinctly names the body elements, often aligning with section titles. Always present it in the same order as the body elements.
Thesis/Purpose – A clear statement of what the document is about and what you want the readers to do/know/believe after reading it. This thesis statement must be in different words than the introduction’s thesis but have the same meaning.
Why this document is important – Conclude business documents reminding readers of the larger business objective the thesis will help meet. This concluding statement needs to be something everyone reading the memorandum agrees with. It is the big-picture business objective that spurs the purpose of this document. As with the introduction you may need a sentence or two between this statement and the thesis. Reference List. The document will end with an APA formatted reference listLinks to an external site. with a minimum of 4 sources. Only include items on the reference list for which you have made an APA in-text citationLinks to an external site. in your document.You are required to have an in-text citation at any place in your memorandum where you have used the ideas, data, or images of others. The reference list items and in-text citations must be In APA format.
Alphabetize the reference list by the first letter of the first author’s last name (or if there are no authors the organization’s name). Both your in-text citation and reference list items will start with the first author’s last name (or if none the organization,) which enables readers to find the reference from the in-text citations. 3. Review and Revise Your Document After completing your document draft, review, revise and edit your document. We will be looking at: Content – Did you include all of the required elements, meeting the specific requirements? (If you have completed the extra credit, did you include the needed in-text citation(s)?)
Coherence – Does your document flowLinks to an external site. so that a reader can follow what you have written as one cohesive document? To check for this, read your document out loud to yourself. Ask yourself as you go if the message is continuous, with one idea leading to the next. Clarity – have you stated specifically what you mean throughout your document? To check for this, look for hedging,Links to an external site. slang, idiomsLinks to an external site., and Links to an external site.vague wordsLinks to an external site. and remove them or replace them with more precise terms. Sentence structure, spelling and punctuation play a role in this, so while we will not be grading you on these directly if they negatively impact the understanding of your document, you will lose points. Concise WordingLinks to an external site. – eliminate meaningless words or phrases, redundant qualifiers, repetitive ideas. Revise your work as needed. Even professional writers revise their work to make it better. If you feel you need extra support with your writing please take advantage of one of the following resources: Review professional and general writing Download professional and general writing resources Attend open help sessions, see the meet your instructors page for times and connection information. Make an appointment with the USF Writing StudioLinks to an external site., you will need to plan ahead Make an appointment with me during office hours through the MS Bookings link on the meet your instructors page.
4. Proofread your Document; Correct Grammar, Punctuation, Sentence Structure, or Spelling Errors There are a number of grammar-checking software programs available to assist you in completing this. While they are not foolproof, they are helpful in suggesting errors you may have made in your document. As these tools are readily available, there is little excuse for writing that has basic proofreading errors. Extra Credit
Points available: up to 5 points
To earn extra credit for this assignment revisit the list of uses from assignment IDL 1, add additional uses up to five beyond your original source. You will present these additional uses at the same level of detail as you do for your original use, so that they all are appropriate for executives. To add these uses you may opt to do one of two things trade sources (not text) with classmates that reviewed different uses, or complete research on your own. Uses you review must be appropriate to your field. You must have sources that support what you say about the uses. Assignment Deliverable, Due Date, Questions, and Submittal
Deliverable: Use the memorandum template Download memorandum template for your assignment. (This is a different template than the one you used for IDL 2 preliminary.)
Download example
Word Count: 900 – 1400 words (not including the reference list). This word count is a guide that is most important on the lower side. The primary goal is to clearly and concisely explain your points to an executive audience.
No quotations and no plagiarism – It is not ethical for students OR professionals to use the words of others or AI to avoid doing their own thinking. Using anything but the most rare quotations in professional work is not acceptable. Also unacceptable is: Using the words of others without quotation marks and in-text citations Using the words of others, but reorganizing the sentence structure (This is a form of plagiarism called inappropriate paraphrasing.) Using the words of others, but changing a few words in each sentence (This is a form of plagiarism called inappropriate paraphrasing.) The words in your document must represent your own thinking, based on the information you have gathered. Citing credible sources from which you got ideas gives you credibility and it is required for this work. If you want to be sure you are clear on what constitutes plagiarism review the USF Avoiding Plagiarism page. (Links to an external site.)
AI Use: You are expected to use AI to check the grammar, punctuation and spelling on this work and for no other purposes. This due date is close to the start of the SHPE conference, plan your time to finish before you leave, you will want to participate in the conference once you are there.
This assignment will close one hour after the deadline. This provides you an hour to address any uploading issues. Any assignments submitted after the deadline but before the assignment closes will be marked late and lose 10% of your earned grade. No late assignments without a documented University-accepted excuse will be accepted. Submittal: All assignments MUST be uploaded to Canvas as a Word document or a PDF. After submitting your assignment check to see that it uploaded and that the document you uploaded is your completed assignment. Resubmittal of a corrupted or incorrect file will result in a 20% penalty per day on the assignment, with no resubmittals accepted after 5 days. Assignments provided by Canvas message or email are not considered submitted as they are not in the correct location for grading.
Assignment Questions: contact Dr. Gobes-Ryan through Canvas messages or sign up for office hours through the MS Bookings link on the “Meet Your Instructor” page in the getting started module. Grading: The attached rubric will be used to grade the assignment. All input reviewed in class and in readings will be considered in the grading. While grammar and punctuation are not graded, language, document structure, and punctuation that make the document difficult to read will be considered in grading. Grading Reviews: To review grades you must schedule an appointment with Dr. Gobes-Ryan. Use the MS Bookings link on the “Meeting Your Instructor” page on the “Getting Started” Module. If office hours conflict with your class or work schedule, send a message on Canvas messages including your available times during work hours (9:30 am – 6:00 pm). (do not send the TA or the other professor these questions). Remember this must be completed within two weeks of grades being released.

For this discussion, you are to describe two studies where inferential statistics were used. For the first study, use the study from the Unit 2 Discussion(see attached). For the second study, you are to locate a peer-reviewed journal article related to the topic of the first study. Be sure the second study is also quantitative and published within the past 5 years. In your discussion post, address the following:Select an inferential statistic used in each study and provide the following information:The sample size
The point estimate
the confidence interval
The p-value if one is listed
Discuss whether you think the result is statistically significant in each of the studies described? What lead you to that conclusion?
What, if any, the effect of increasing the sample size by 100 would have on the statistical significance of each of the studies?
Discuss whether you think the result is practically significant in each of the studies described?What lead you to that conclusion?
What, if any, the effect of increasing the sample size by 100 would have on the practical significance of the studies?
Which, if any, is more important: statistical or practical significance? Support your position using at least one internal and one external source.
Please be sure to validate your opinions and ideas with citations and references in APA format.

The course is regression analysis, and we use R as programming languages. Please follow the following PDF to write a dataset project introduction report. The link for the dataset is: https://www.kaggle.com/datasets/mirichoi0218/insur…

FYI, your job is to do the following:
(1) Revise “plot_points()” so that it can display three classes (i.e, the three iris types) with different colors and shapes.
(2) Call “plot_mode()” with two features (out of the four features). As you are going to have six pairs of two features, you will generate six plots.
Regarding “display_tree(),” if you have difficulty in using other ready-made visualization packages, you can just use “display_tree()” in the original Graphical_example.ipynb. Please let me know if you need further clarification.
(1) you were asked to display scatter plots for the three classes, each of which has a different color and shape.
(2) you were asked to display decision trees with different depth values (say, 1, 2, or 3 for example).
And I Put an example pdf file.

Imagine that you are a part of a big data project team that is trying to understand why the bank customers are defaulting on loans. You can look at factors alike age, gender, marital status, income and number of children. Please see attached for the complete question, we are only focused on the discovery phase.

Question 1) An article in Communications of the ACM [(1987, Vol. 30(5), pp. 53–76] reported on a study of different algorithms
for estimating software development costs. Six algorithms were applied to eight software development projects and the percent
error in estimating the development cost was observed. The data are in Table. Also, a csv file is posted for you to use to analyse
these results.
(a) It is assumed that there might be nuisance effects due to differences in projects. Based on this, what kind of experiment
design is this? Which factor is the main factor of interest? How are “projects” considered in this example, as replications or
something else?
(b) Use Minitab to create boxplots of responses for algorithms. Minitab Graph->boxplot->simple boxplot (select algorithm as
the categorical variable) . What do you observe based on boxplot?
c) Do the algorithms differ in mean cost estimation accuracy? Use α = 0.05. (Minitab->Stat->ANOVA->General Linear Model)
(d) After running part b, you can use stat->Anova->General Linear Model->comparisons to create multiple comparisons using
Fisher method. You can create groups means, groups that are significantly different or not different, and confidence plots of
difference of means. Which algorithm would you recommend for use in practice based on lower mean error, and low variability.
Question 2) An article in IEEE Transactions on Semiconductor Manufacturing (1992, Vol. 5, pp. 214–222) described an
experiment to investigate the surface charge on a silicon wafer. The factors thought to influence induced surface charge are cleaning
method (spin rinse dry or SRD and spin dry or SD) and the position on the wafer where the charge was measured. The surface
charge (×1011 q / cm3) response data follow:
a) How many replications does this experiment have for each treatment?
b) State the null and alternative hypotheses that we need to test in this problem (main effects and interaction)
c) Write down the matrix that will show the contrast signs for each effect and interaction effect (Assume
Cleaning method is factor A, and test position is factor B)
d) Estimate the factor effects and interaction effect using contrasts. Which effects are big compared to others?
e) Estimate Sum of squares using contrasts and set up the missing parts in the ANOVA table manually
Analysis of Variance for charge
Source DF Seq SS Adj MS F P
A ___ ____ ____ ___ >0.05 or <0.05 B ___ ____ ____ ___ >0.05 or <0.05 AB ___ ____ ____ ___ >0.05 or <0.05 Residual Error ___ ____ ____ Total ___ 122.347 f) Using alpha=0.05 determine which factors and interaction is significant. (perform critical value approach) g) Draw main effect plot of A (cleaning method) -manually. X axis will show low and high levels of A, and y- axis will show average response at low and high levels of A.