Expert Answers

CIS 355:  Business Data Warehousing and Dimensional Modeling 
(Term: Spring 2021, BDA Program)
Quiz 3, 

Name: ____________________________

Instructions

1)    Duration: 30 minutes
2)    This is a closed book quiz.
3)    Be brief and neat. 
4)    Try to answer all questions.

Good Luck!

Question 1: (1.5 points) 
Determine whether the following statements are true or false.  If false, explain why the statement is false, and how to make it true.
1.    ETL (or data load) in data warehouse is an easy task and takes little time.

2.    Overlapping dimensions refer to the situation where two dimension tables have “just enough in common” to support drill-across.

3.    Drill across refers to an operation that navigates among different levels of data ranging from the most summarized to the most detailed.

Question 2: (2.5 points)

The following is a partial Star schema that models student enrollment in courses taught by faculty members at ASU.

a.    Why there is no measurement in the “enrollment_fact” table? What type of fact table is it?

b.    Is it possible to add a tracking fact/measurement to the “enrollment_fact” table? What value will the tracking fact take?

c.    If we want to answer the question “what course is the most popular course?” where popularity of the course is measured by the number of students enrolled in a course, what tables do you need? What SQL query operations do you need?

Question 3: (4 points)

The following is the ETL data flow task we discussed in class to load data (from transaction DB “AdventureWorks2014”) into the dimension table “DimSalesTerritory” in the data warehouse. Based on the data flow, answer the following questions:

 
a.    What does the node “OLE DB Source” do in the data flow task?

b.    There are two branches beneath the “Slowly Changing Dimension” node, please briefly discuss (using two sentences maximum) what each of the branches does.

c.    When the data flow task is executed, we noticed that 10 rows of data were affected from “OLE DB Source” to “Lookup” to “Slowly Changing Dimension.” However, no action (data affected) seems to be taken from “Slowly Changing Dimension” node to “Insert Destination” and “OLE DB Command” (see image below). Why is it the case?

d.    Now suppose that the name of the territory for TerritoryID = 3 has been changed from ‘Central’ to ‘Midwest’ in the transaction DB “AdventureWorks2014” since the last ETL run.  If we re-run the ETL process, which path of the data flow task will be affected and what are the number of rows (records) affected on the path?
 

TEL431

L4: Quiz 

• 2021 update

 Question 1

1 / 1 pts

Empathic listening

•   makes the person talking feel listened to and understood.
•   an emotional response to the talker's body language.
•   offering an immediate solution.
•   takes extra time for the listener.

 Question 2

1/ 1 pts

Empathic listening is useful when

•   trust is low
•    you do not understand the other person
•   there is a need to release emotion
•   the positive atmosphere is in jeopardy
•   all of the above
•   some of the above

Question 3

1 / 1 pts

According to the National Staff Development Council, veteran educators might best provide insight to educators who are new to the field by (mark all that apply):

•   providing basic career guidance to individuals
•   giving advice to individuals
•   providing group-based mentoring
•   Never providing advice

 Question 4

1 / 1 pts

The best way to show someone you are listening is to

•   ask a lot of questions
•   ask questions with a yes/no answer
•   never ask questions
•   don't ask too many questions

Question 5

1 / 1 pts

Empathy is the ability to put yourself into the personality of another person. This allows you to better understand that person's emotions or feelings. Being empathic strengthens interpersonal effectiveness of an individual's personal and professional life.

•   True
•   False

 Question 6

1 / 1 pts

Traditional ideas of mentoring involve a more senior individual within the protégé's organization, who serves as a teacher, adviser, or sponsor. Higgins and Kram expand upon this notion by

•   suggesting mentors work in another area of the organization so as to add diversity.
•   promoting individuals rely on multiple mentors for developmental support throughout their careers.
•   suggesting senior colleagues need mentors the most, and should seek mentors outside their organization.
•   making it clear that mentors and mentees need to work in unison to address the organization's priorities.

 Question 7

1 / 1 pts

A developmental network involves

•   one primary mentor-mentee relationship that spans many years.
•   developing a network of administrators who can help you make decisions.
•   strong relationships in the workplace.
•   multiple concurrent relationships

 Question 8

1 / 1 pts

Four broad categories of change that lead Higgins and Kram to develop the Developmental Network perspective are: globalization, ___________, virtual businesses, the ever-changing nature of organizational work for the protégé and for the mentor, and increasing workplace diversity.

•   better leadership techniques
•   technology
•   prioritization
•   stable cultures

Question 9

1 / 1 pts

Mentoring scholars/researchers suggest there are two types of support. These include

•   mentor support and protégé support.
•   career support and emotional support.
•   mentor support and mentee support.
•   career support and psychosocial support.

 Question 10

1 / 1 pts

A developmental network consists of relationships with individuals a protégé feels are important to his or her career development _______________.

•   at a time when it is important for career development.
•   throughout their career.
•   and include both personal and professional connections.
•   None of the above
•   All of the above

 Question 11

1 / 1 pts

For Higgins and Kram, developers include anyone in the protégé's development network, whether they provide career psychosocial development assistance.

•   True
•   False

 Question 12

1 / 1 pts

Establishing many mentors, most of whom work within the protégé's organization, is the most advantageous structure to professional development.

•   True
•   False

 Question 13

1 / 1 pts

On average, when a relationship demonstrates interdependence, reciprocity, mutuality, and frequency of communication, it is considered to have

•   weak ties in terms of relationship strength, which produces individuals who are highly motivated
•   strong ties in terms of relationship strength, which produces individuals who are highly motivated.
•   weak ties in terms of relationship strength, which produces individuals who are seldom motivated.
•   strong ties in terms of relationship strength, which produces individuals who are seldom motivated.

 Question 14

1 / 1 pts

__________ and ____________ are the two factors that determine a developmental network typology.

•   Internet connectivity, computer access
•   distance from the protégé, communication tools
•   relationship strength, collaboration capabilities
•   network diversity, relationship strength

 Question 15

1 / 1 pts

In the developmental network model by Higgins and Kram, the most advantageous structure is when developers (a.k.a. mentors) have relationships with one another.

•   True
•   False

 Question 16

1 / 1 pts

The type of network that has the strongest ties and the highest range of diversity is a/an _____________ network.

•   traditional
•   receptive
•   entrepreneurial
•   opportunistic

 Question 17

1 / 1 pts

Mentoring relationships that are denoted as having strong ties are more likely to ____________.

•   last a long time.
•   have high levels of trust
•   survive when others fail.
•   None of the above

Question 18

1 / 1 pts

A possible outcome or consequence for having an entrepreneurial-typology developmental network is

•   the ability to see career changes such as mergers, acquisitions, downsizings, etc., as developmental opportunities.
•   that the protégé is more inclined to start his or her own business.
•   the inclusion of more mentors in the developmental network.

 Question 19

1 / 1 pts

A possible outcome or consequence for having an entrepreneurial-typology developmental network is

•   clarity about one's identity
•   clarity about personal values, strengths, and weaknesses
•   Increased awareness of developmental needs, reactions, and patterns of behaviors
•   All of the above
•    None of the above

Question 20

1 / 1 pts

Motivation to support a protégé is weak when emotional ties are strong between the developer and the protégé.

•   True
•   False

ASB378

 Module 2 Quiz

Question 1

1 / 1 pts

In the video, “Immigrant America: The High Cost of Deporting Parents,” where was Ray Jesus born?

•   ParaguayCorrect!
•   Guatemala
•   United States
•   Mexico

Question 2

1 / 1 pts

According to Cornelius and Tsuda reading (“Controlling Immigration: The Limits of Government Intervention”), in Western Europe, regional trade liberalization, combined with large flows of development aid from richer to poorer EU member countries, halved wage disparities and transformed labor exporters like Italy and Spain into labor importers

•   True
•   False

Question 3

1 / 1 pts

According to the video, “Walls of Shame: The US-Mexican Border,” the citizen-group, American Border Patrol uses lots of high-tech equipment to track lots of illegal immigrants entering the US and then goes out and captures and apprehends them on their own without the assistance of U.S. Border Patrol agentsou Answered

•   True 
•   False 

Question 4

1 / 1 pts

According to the first lecture of this module (“Overview, Causes, and Impacts of Global Migration”), which of the following is false about high-skilled and professional immigrants?Correct!

•   They are all white people who come from Europe and Canada.
•   They tend to come from middle class or elite backgrounds and are highly educated
•   Many are originating from less developed countries from the Global South such as China, India, and the Philippines.
•   They are seeking better professional and educational opportunities abroad.

Question 5

1 / 1 pts

According to the Lechner reading (“Global Migration: How New People Change Old Places”), which European country has the secular-republican model of immigrant policy?

•   United Kingdom
•   GermanyCorrect!
•   France
•   Netherlands 

Question 6

1 / 1 pts

According to the Cornelius and Tsuda reading (“Controlling Immigration,” assigned for the Immigration Policy class), it is very easy to measure policy gaps between official immigration control policies and their actual policy outcomes

•   True Correct!
•   False

Question 7

1 / 1 pts

According to Cornelius and Tsuda reading (“Controlling Immigration: The Limits of Government Intervention”), by adopting more restrictive immigration policies, receiving-country governments have unwittingly increased the demand for people smugglers, whose services raise the probability of evading border controls.orrect!

•   True 
•   False 

Question 8

1 / 1 pts

According to Cornelius and Tsuda reading (“Controlling Immigration: The Limits of Government Intervention”), immigration policy gaps occur because:

•   Governments have continued to rely on policy instruments with inherent flaws that fail to deter unauthorized immigrants and asylum seekers and produce serious unintended consequences.
•   Domestic political constraints make it difficult for governments of labor-importing countries to implement their control measures effectively.You Answered
•   Officially declared immigration policy is often quite different from actual intentions.
•   All of the above 

Question 9

1 / 1 pts

According to the video, “Immigrant America: The High Cost of Deporting Parents,” Ray Jesus, the deportee from the US, has a wife and children in Utah.Correct!

•   True 
•   False 

Question 10

1 / 1 pts

According to the first lecture of this module (“Overview, Causes, and Impacts of Global Migration”), the total number of global migrants is still only 10 percent of the world’s population of 6.8 billion.

•   TrueCorrect!
•   False 

Question 11

1 / 1 pts

According to the second lecture of this module (“Local Host Society Responses to Immigration”), which of the following is false?

Correct!

•   Undocumented immigrants have higher crime rates than American citizens 
•   Muslim immigrants are not significantly increasing the threat of terrorism 
•   Americans are three times more likely to be struck by lightening than to die in a terrorist attack 
•   Immigrants use social welfare less than Americans of the same socioeconomic leve

Question 12

1 / 1 pts

According to the third lecture of this module (“Transnational and Diasporic Migrant Communities”), diasporic communities consist of people scattered among various nation-states who maintain social connections with each other.

•   True ou Answered
•   False 

Question 13

1 / 1 pts

According to the Tsuda reading (“Unequal in the Court of Public Opinion”), which of the following is false:

•    It is quite clear that most of the public’s anti-immigrant sentiment is directed not at general or legal immigrants, but at illegal immigrants.You Answered
•   Undocumented immigrants are perceived as a threat to American society because the public greatly overestimates their number.
•   Undocumented immigrants are the target of the public’s wrath not only because they are perceived a lawbreakers, but because they are often perceived as a burden and threat to the host society.
•   None of the above

Question 14

1 / 1 pts

According to the third lecture of this module (“Transnational and Diasporic Migrant Communities”), most global migrants stop maintaining transnational social connections to their countries of origin and do not live in transnational communities.

•   TrueCorrect!
•   False

Question 15

1 / 1 pts

According to the first lecture of this module (“Overview, Causes, and Impacts of Global Migration”), migration is a new characteristic of our modern, globalized world.

•   TrueCorrect!
•   False 

Question 16

1 / 1 pts

According to the second lecture of this module (“Local Host Society Responses to Immigration”), almost all undocumented immigrants are illegal border crossers who come through the U.S.-Mexican borderou Answered

•   True
•   False 

Question 17

1 / 1 pts

According to the first lecture of this module (“Overview, Causes, and Impacts of Global Migration”), the number of people living outside their country of birth has not increased that dramatically since 1970

•   TrueCorrect!
•   False

 
CIS 355:  Business Data Warehousing and Dimensional Modeling 
(Term: Spring 2021, BDA Program)

Assignment 2 (individual work)

Submission instructions: 

• Please upload a document with your SQL queries as well as query results, charts, or graphs to Canvas

1.    In your Assignment 1, you were asked to write an SQL query to summarize total sales by different product categories over years. Now, using your results from your query and plot a chart of total sales with x-axis being the years (2010-2014) and y-axis being the total sales. Your chart should look like the following but with all three product categories (accessories, clothing, bikes) and total sales. Copy and paste your chart below, and briefly discuss the step-by-step instructions you followed to create your chart.

2.    Use your data warehouse “YourASURITE” to generate a report of total internet sales amount for different products (using English product names) by calendar year. Sort your report by ProductName first, then by CalendarYear. Please copy/paste your SQL query as well as your query results (top 10 rows only) below.

3.    Add calendar quarter in your report from (2). Again sort your report by ProductName first, then by CalendarYear, finally by CalendarQuarter. Please copy/paste your SQL query as well as your query results (top 10 rows only) below. What is the BI concept or terminology for the operation from (2) to (3)? Assuming your report in (2) is correct, what would you check to make sure your report in (3) is consistent with that in (2)?

4.    Use our sample data warehouse “AdventureworksDW2014” to generate a report of total internet sales amount for different product lines (using ProductLine) by calendar year and sales territory country. You will need to use the following tables: DimDate, DimProduct, DimSalesTerritory, and FactInternetSales. Sort your report by ProductLine first, then by CalendarYear, finally by Territory country. Please copy/paste your SQL query as well as your query results (top 10 rows only) below.

5.    [For you to think] Would you be able to create a map with the above data in report (4) overlay on top of the world map (with Total Sales as bubble size, Product Line as categories in each bubble) like something below?

CIS 355:  Business Data Warehousing and Dimensional Modeling 
(Term: Spring 2021, BDA Program)

Assignment 1 (individual work)

1.    In this assignment, you need to continue building your DW (named YourASURITE) on the SQL Server. Your finished DW will include 4 tables (an InternetSales fact table and three dimension tables: Customers, Dates, and Products). The star schema of your DW will look like below.

Please refer to the lecture notes “CIS 355 - DW hands-on CreateDW&ETL.pptx” slides 9-15 for the SQL scripts to create your DW.
2.    After you build your DW in (1), you need to load data into your DW tables. Please refer to the lecture notes “CIS 355 - DW hands-on CreateDW&ETL.pptx” slides 17-21 for the SQL scripts to load data into your DW (4 tables).  When running the SQL scripts, please pay attention to (1) the order of the 4 tables where data will be inserted, and (2) execute the SQL scripts only once; otherwise you will have repeated observations (with just different SK fields).

3.    Develop an SQL query to find out the order quantity of various products (using product name) by customers (including customer name, occupation, and age). Your query results need to be first sorted by customer name, then by product name.  Please copy/paste your SQL query as well as your query results (top 10 rows only) below.

4.    Write an SQL query to summarize total sales by different product categories over years. Your total sales information needs to be first sorted by product categories, then by years. Please copy/paste your SQL query as well as your query results below.

Submission instructions: 

• For part (1) and (2) above, you do not need to submit anything with this document; we will check your DW tables to grade your work.
• If successfully loaded, Customers table will have 18,484 records; Dates table will have 3,652 records; InternetSales table will have 60,398 records; and Products table will have 397 records.
   

TEL431 L1: Quiz 
Questions 10
Score for this quiz: 20 out of 20
 

Instructions
This quiz is open note and is not timed.
From the lesson 1 overview and learning materials page: 
•    Read Key Competencies for Lifelong Learning: European Reference Framework
•    Watch the Daniel Pink TEDtalk, based on his book, A Whole New Mind (1:22 long)
Then take the following 10-question quiz worth 20 points
 
Question 1
2 / 2 pts
From the perspective of the European Reference Framework, why is it important to engage in lifelong learning?

• To be competitive in your choice of career, so that you can attain the highest entry-level salary possible.
• To be successful in the ever-changing workplace, which includes such factors as growing internationalism, rapid rate of change, and new technologies.
• To maximize your impact in your future job.
• To address the needs of learners in a way that will prepare them to be competitive.

 
 
Question 2
2 / 2 pts
According to the European Reference Framework for Key Competencies for Lifelong Learning, being fluent in a second language

• Is essential, because it calls for skills such as mediation, and intercultural understanding.
• Allows workers the ability to work in jobs that support international clients.
• Wires the brain in a more sophisticated way, which supports the development of critical thinking skills.
• All of the above

  
Question 3
2 / 2 pts
The most relevant technology skills needed for 21st-century learners are

• Keyboarding and basic word processing skills.
• Troubleshooting, maintenance, and upgrades of technology devices.
• the ability to search, collect, and process information, then access it for relevance.
• the ability to stay updated in professional learning technology tools, accessing tools, and learning new technology tools quickly once it is determined a tool is fitting for a professional need.

  
Question 4
2 / 2 pts
The most important skill in learning to learn is the ability to

• Know your preferred learning strategies, recognize strengths and weaknesses, and be able to search for educational and training opportunities, along with guidance and available support.
• Know what resources are available for independent and personalized learning.
• Know how to navigate the Internet in search for experts who might be good mentors for you.
• None of the above.

  
Question 5
2 / 2 pts
From the 21st century perspective, being an entrepreneur requires being able to act on creative, innovative, and possibly risky ideas, and the ability to plan and manage projects. The skills required include:

• Project management, effective representation and negotiation, and the ability to work by oneself as well as in teams, and assessing one's strengths and weaknesses.
• Working with others, networking, and establishing a strong digital social network around professional interests.
• Leadership.
• Facilitating diverse groups of people involved in a project.

 
 
Question 6
2 / 2 pts
According to Daniel Pink, basic left-brain abilities such as being logical, linear, and sequential still matter, but they matter less; a different set of abilities matter more. Those abilities are:

• right-brained abilities such as artistry, empathy, inventiveness, and big-picture thinking.
• mid-brained abilities such as communicating, collaborating, and critiquing.
• brain-stem abilities such as realizing when an idea has been exhausted and knowing when to start over.

 
 
Question 7
2 / 2 pts
According to Pink, jobs of the future

• will likely involve some routine.
• are not known.
• will require at least a bachelor's degree.
• will definitely require knowing how to use technology.

  
Question 8
2 / 2 pts
No one knows the jobs of the future. But we can state the _________ skills that will be important.

• Recycling
• Cognitive
• Data analysis
• Physical

 
Question 9
2 / 2 pts
Pink believes the skills required for future jobs will involve dealing with novelty, nuance, and customization. With this in mind, he suggests educators ________the relying on routines, right answers, and standardization.

• rely more heavily on
• move away from

 
Question 10
2 / 2 pts
The six abilities that matter most in the 21st century, according to Pink, are design (not just function), story (not just argument), non-routine, symphony/big picture thinking and putting the pieces together (not just focus), empathy (not just logic), play (not just seriousness), and meaning (not just accumulation). For educators, this means that learners should ______________ new metrics/ways of measuring, get real about STEM (science, technology, engineering, and math) where problems are poorly defined, multidisciplinary, and has multiple answers, none of which are perfect. 3) tear down the walls between disciplines and between the walls in the schools, 4) infuse arts education throughout the curriculum, and 5) promote and defend autonomy.

• reject
• experiment with
• adopt

Take-home Quiz #6 

Instructions

Please answer the following questions. You can take this quiz only once. You may use all materials from class while taking the quiz. However, you have to take the quiz individually.

Attempt History

 Question 1

1 / 1 pts

A key difference between integrative and distributive bargaining is that the goals of the parties in integrative bargaining are not mutually exclusive.

Correct!

•   True
•   False

Question 2

3 / 3 pts

Please match the concept with the right definition.

Correct!

Interests

Correct!

Position

Correct!

Logroll

Correct!

Nonspecific compensation

Correct!

Expanding the pie

Superordination

 Question 3

2 / 2 pts

Put the four key steps of the integrative negotiation process in order.

Correct!

1

2

Correct!

3

Correct!

4

 Question 4

1 / 1 pts

A negotiation's concern for what is "fair" or "right" is considered which type of interest?

•   Substantive interest
•   Relationship interest
•   Process interestCorrect!
•   Interest in principle

 Question 5

1 / 1 pts

Redefining, recasting, or reframing a problem can be helpful to generate alternative solutions.

•   True
•   False

 Question 6

1 / 1 pts

What is false about the difficulties associated with integrative negotiations?

•   People do not spend time looking for integrative solutions.
•   Distributive negotiations are especially successful when there is only limited time to come to an agreement.
•   Not having settled in a past distributive negotiation increases the chance of an impasse at a future negotiation.
•   People expect negotiations to be win-lose instead of win-win thereby reducing their willingness to engage in distributive bargaining. 

Question 7

1 / 1 pts

Integrative bargaining is always better than distributive bargaining.

•   True
•   False

WPC300

Assignment 8: Clustering Analysis
Started: Oct 

Quiz Instructions
•    Read the Assignment Instructions.
Actions
•    Start with datafile: US Demographics.jmp
•    Change the file name to: YourFirstName_YourLastName_Assignment8.jmp
•    You must use JMP to answer the following multiple-choice questions. 
•    Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture. 
 

Question 1                          2.5 pts
Execute a hierarchical clustering to find out the segmentation among the US states based on the attributes mentioned in the instructions.  Submit parallel plots diagram to show the number of clusters obtained from the analysis. Make sure to show different colors for the different clusters.
Hint: put "State" into "Label."
Upload (attached) 

 
Question 2                           2.5 pts
Based on the hierarchical clustering analysis, which cluster of States have low population and low physical activities comparing to other clusters?

• Alabama, Indiana, Kentucky
• California, Texas, New York
• Kansas, Idaho, Michigan
• Tennessee, Alaska, Ohio

 
Question 3                                 2.5 pts
For a wellness campaign, where your goal is to create awareness for people’s health and weight related chronic illnesses (such as obesity), which cluster (based on hierarchical clustering analysis) would be an ideal target for an initial launch?

• Cluster #1
• Cluster #3
• Cluster #2
• Cluster #4

 
Question 4                       2.5 pts
Based on the hierarchical clustering analysis, submit a screenshot of the appropriate US map with colored clusters of the States. 
Upload (attached) 
 
Question 5                       2.5 pts
Which of the following statements is true about cluster #4 from the hierarchical clustering analysis?

• High household income and high physical activity
• High population and high obesity
• Low household income & low obesity
• Low population and very high obesity

 
Question 6                       2.5 pts
Execute a k-means clustering analysis using the same data attributes with a cluster range between 3 and 15. How many distinct clusters did you find from your analysis?

• 10
• 6
• 4
• 8

 
Question 7                     2.5 pts
Based on the K-Means clustering analysis in Q6 , what are the States that don’t cluster together?

• Kansas & New Mexico
• California & Utah
• Texas & Florida
• Colorado & Minnesota

 
Question 8                        2.5 pts
Based on K-means clustering analysis, which two States would appropriate for launching your campaign?

• Colorado & Minnesota
• New York and Texas
• Alabama & Mississippi
• Maryland & New Jersey

 
Question 9             2.5 pts
Based on K-means clustering, which of the following States you definitely won’t choose to run your wellness campaign?

• Louisiana
• West Virginia
• Oklahoma
• Vermont

 
Question 10                   2.5 pts
Submit the JMP file with saved scripts for hierarchical and k-means clustering.

(provided)

WPC300

Practice Test (Practical) 

Instructions

PRACTICE Practical Exam Instructions

This exam has a total of two sections. You are required to use two sets of data to answer all the questions. Please see the individual instructions for each section. The total time allowed for this exam is 75 minutes. You must complete the exam in one seating. You will need JMP Pro and Excel software to analyze data and answer questions. 

Note: You are expected to work individually to complete this exam before the due date. Getting help from outside resources other than what is made available to you via the canvas course site is considered a violation of the code of academic integrity for which you will be liable for the consequence. 

Attempt History

Submitted Mar 

Score for this attempt: 20 out of 20

 Data background

The sample includes various demographic and blood test responses for 442 diabetes patients (respondents). The response variable Y is a quantitative measure of disease progression one year after baseline measurements were taken. The ten variables measured at baseline time are age, gender (1 = male, 2 = female), body mass index (BMI), average blood pressure (BP), and six blood serum measurements (Total Cholesterol, LDL, HDL, TCH, LTG, & Glucose). The response Y Binary is constructed from the response Y and defined as high if Y is above 200 or low otherwise.

Section A:

Instructions: 

• Use the following data file for this section: SampleDiabetes.xlsx  
• Remember the honor code.
• Use Excel to prepare your responses to the questions in this section
• Note that sometimes numbers have been rounded.

Create a new column using a vlookup() function to categorize the age variable into age categories as follows:

Question 1

1 / 1 pts

Using a pivot table, determine which of the following statements is incorrect.

•   Category 4 has 97 respondents Correct!
•   Category 3 has 54 respondents
•   Category 5 has 73 respondents
•   Category 2 has 90 respondents

Question 2

1 / 1 pts

Using a pivot table, determine which of the following statements is incorrect about the average age of respondents in each age category.

•   Category 3 average age is 54.0 years
•   Category 2 average age is 63.8 years
•   Category 4 average age is 44.9 years!
•   Category 1 average age is 71.2 years

Question 3

1 / 1 pts

Create a pivot table pie chart for people of age 40 or older using the same age categories as before, determine which of the following statements is correct.

•   Category 3 has 28% of the respondents
•   Category 2 has 20% of the respondentst!
•   Category 2 has 28% of the respondents
•   Category 4 has 22% of the respondents

Section B

Instructions

• Use the following JMP data file for this section [Diabetes.JMP]
• Remember the honor code.
• Use JMP Pro to prepare your responses to the questions in this section
• Note that sometimes numbers have been rounded.

 Question 4

1 / 1 pts

Which of the following statements is not correct based on the sample data provided?

•   The mean for LDL is 115
•   The upper limit of the 95% confidence interval for BP is 95.9
•   The median for Total Cholesterol is 186
•   The standard deviation for HDL is 0.6152

Question 5

1 / 1 pts

Looking at the distribution of BMI, you observe that the data centrality is measured as:

•   n = 442 
•   Standard Error = 0.21
•   Standard deviation = 4.41orrect!
•   Mean = 26.4

Question 6

1/ 1 pts

Looking at the distribution of Glucose, you observe that the distribution spread is measured as:Answered

•   Mean is 91.3
•   95% confidence interval is 90.2 to 92.3
•   Standard error is 11.5
•   Interquartile range is 15

Question 7

1 / 1 pts

It is generally believed that the average population age is 50. You claim that the population average age is less than 50. Perform a statistical test on the sample to see if the average age for the sample is consistent with your hypothesis (use a margin of error of 5%). What is the p-value from the test?

•   0.05Correct!
•   0.0089 
•   0.9911 
•   0.0179

 Question 8

1/ 1 pts

It is generally believed that the average population age is 50. You claim that the population average age is more than 50. Perform a statistical test on the sample to see if the average age for the sample is consistent with your hypothesis (use a margin of error of 5%). What can you conclude?

•   We fail to reject the null hypothesis
•   We accept the null hypothesis
•   We do not have enough information to make a judgement on the null hypothesisAnswered
•   We reject the null hypothesis

Question 9

1 / 1 pts

Perform a pairwise correlation analysis of the variables Y, age, BMI, BP, Total Cholesterol, LDL, HDL, TCH, LTG, & Glucose in the sample suggests that:

•   The population has a significant negative correlation between TCH and Total Cholesterol
•   The population has no correlation between Total Cholesterol and LDLt!
•   The population has a significant negative correlation between HDL and TCH
•   The population has a significant negative correlation between Y and BMI

Question 10

1 / 1 pts

If we are interested in determining a possible cause and effect relationship where BMI and Age are causing disease progression (Y), _____ is the independent variable and ____ is the dependent variable?

•   Age, BMI respectivelyAnswered
•   BMI, Y respectively
•   BMI, Age respectively
•   Y, BMI respectively

Question 11

1 / 1 pts

Perform a simple linear regression to predict Y using respondents’ BMI. What is the correct equation for the regression line?

•   Y = 10.2*BMI
•   BMI = -118 + 10.2*YCorrect!
•   Y = -118 + 10.2*BMI
•   BMI = 21 + 0.034*Y

Question 12

1 / 1 pts

Perform a multiple regression analysis (with a margin of error of 5%) that examines all of the variables in the sample (excluding Y binary) as potential predictors of Y. Which of the following conclusions can be made based on the analysis without removing any of the predictor variables?

•   LDL is a significant predictor in the model, LTG is not.
•   TCH is a significant predictor in the model, Glucose is not.Correct!
•   BMI is a significant predictor in the model, HDL is not.
•   Age is a significant predictor in the model, Total Cholesterol is not.

Question 13

1 / 1 pts

After performing model building by applying backward deletion to the model described in Q12, which of the following conclusions is valid based on the final model?

•   Glucose is not a significant predictor, but Gender is
•   Total Cholesterol is not a significant predictor, but BP isYou Answered
•   HDL is not a significant predictor, but LTG is
•   Age is not a significant predictor, but LDL is

 Question 14

1/ 1 pts

Based on the final model developed in Q13, which is the strongest predictor in the model?

•   Intercept
•   BMIou Answered
•   Total Cholesterol 
•   Gender

Question 15

1 / 1 pts

Based on the final model developed in Q13, which is the weakest predictor in the model?ct!

•   Gender
•   Total Cholesterol
•   Intercept
•   BMI

Question 16

1 / 1 pts

How much of the variation in the dependent variable can be explained by the final regression model developed in Q13?

•   50.8%You Answered
•   51.5%
•   <.0001
•   We cannot determine this quantity

Question 17

1 / 1 pts

Is there a multicollinearity concern for the final model developed in Q13?

•   There is a multicollinearity problem in the final model and we should delete the LTG variableCorrect!
•   There is a multicollinearity problem in the final model and we should delete the Total Cholesterol variable
•   There is no multicollinearity problem in the final model
•   There is a multicollinearity problem in the final model and we should delete the Gender variable

Question 18

1 / 1 pts

The Y Binary variable was developed to categorize respondents into high and low development of Diabetes over the year since their baseline measurements were taken. What proportion of high development respondents are female? Answered

•   75.3%
•   69.6%
•   24.7%
•   30.4%

Question 19

1 / 1 pts

In an initial logistic regression analysis attempting to establish if all of the variables (excluding Y) in the sample can predict (with a margin of error of 5%) the level (high/low) of the disease, it can be concluded that:u Answered

•   Some of the predictors are not significant and can be deleted from the model
•   The overall model is significant in predicting the level of development of the disease
•   The model accuracy can be determined by the confusion matrix
•   All the other answer choices are correct

Question 20

1 / 1 pts

In the final logistic regression model to predict/classify Y binary, which of the following statements is true:

•   77 respondents were correctly classified by the model as high disease development
•   291 respondent were correctly classified by the model as low disease development
•   44 respondents were incorrectly classified by the model as low disease developmentCorrect!
•   All of the other answer choices are correct

wpc300 Lab 8: Clustering
Started: March

Quiz Instructions
•    Start with datafile: Presidential Elections.jmp
•    Change the file names to: YourFirstName_YourLastName_presidential.jmp
•    Review what we did in the lab.
•    You must use JMP to answer the following multiple-choice questions. 
•    Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture. 
 
Question 1                    2 pts
Based on a hierarchical clustering on the election results, how many optimal clusters of States did you get from your analysis?

• 4
• 6
• 5
• 8

 
Question 2                  2 pts
Which cluster of States has the lowest proportion of Democratic voters in the Presidential elections?

• Alaska, Nebraska, Idaho, Wyoming, Utah
• Iowa, Wisconsin, Pennsylvania, Minnesota
• Virginia, Texas, Indiana
• Arizona, Nevada, New Hampshire, Colorado, Florida

 
Question 3                  2 pts
If you are an advisor for a Republican presidential nominee, for which States would you not run many campaign ads against your opponent who is a Democratic presidential nominee?

• Iowa, Wisconsin, Pennsylvania, Minnesota
• Alaska, Nebraska, Idaho, Wyoming, Utah
• Arizona, Nevada, New Hampshire, Colorado, Florida
• Virginia, Texas, Indiana

 
Question 4                 2 pts
Show a parallel plot graph to demonstrate how different States are clustered together based on hierarchical clustering analysis? Submit a screen shot.
Upload 
  

Question 5             2 pts
Perform a K-means clustering with initial number of cluster seed to vary between 3 and 10. What is the optimal number of clusters did you get from this analysis?

• 8
• 4
• 5
• 6

Question 6               2 pts
Show a parallel plot graph to demonstrate how different States are clustered together based on the K-means clustering analysis? Submit a screenshot.
Upload 

Question 7                    2 pts
Based on the K-means clustering, show how States are grouped together using colored coded US Map. Submit a screenshot.
Upload 
  

Question 8                    2 pts
Upon evaluation of cluster means obtained from K-means clustering, which cluster has the lowest overall democratic percentage of voters over the 9 election cycles?

• 2
• 4
• 8
• 3

Question 9                      2 pts
Upon evaluation of cluster means obtained from K-means clustering, which cluster has the highest overall democratic percentage of voters over the 9 election cycles?

• 8
• 4
• 3
• 2

Question 10                     2 pts
Which cluster depicts swing States where the percentage for both democratic and republican nominees are similar in the last couple of election years?

• 7
• 2
• 6
• 8