Question 1: For each of the transactions identified, state how the asset, liability and/or equity accounts increase (↑), decrease (↓) or remain unchanged (-). Name the account. (a. is an example)                                                                                                

1.Which of the following scenarios would it be appropriate to use a normal approximation for the sampling distribution of the sample proportion?

Select one:

a.) A researcher wishes to find the probability that more than 60% of a sample of undergraduate students from UNC will be female. She samples the first 42 students that walk into the gym on Monday morning. The population proportion of undergraduate females at UNC is known to be 60.1%.

b.)A researcher wishes to find the probability that less than 5% of a sample of undergraduate students from Appalachian State University will be between the ages of 25 and 34. He randomly samples 50 undergraduate students from the student database. The proportion of undergraduates between the ages of 25 and 34 is 5.3%.

c.)A grad student at NC state wants to know how likely it is that a group of students would be made up of more than 27% graduate students. She will randomly select 38 students and ask them if they are a graduate student or an undergraduate student. The population proportion of grad students at NC state is 26.6%.

d.)A full-time student at Fayetteville State University wants to know how likely it is that a group of students would be made up of less than 70% full-time students. She will ask 30 people that she sees parking in the parking deck if they are full-time or part-time. The population of full-time students at Fayetteville State is known to be 72%.

2. In the general population in the US, identical twins occur at a rate of 30 per 1,000 live births. A survey records 10,000 births during Jan 2018 to Jan 2019 and found 400 twins in total. Which of the following are true?

Select one or more:

The proportion of twin births during Jan 2018 to Jan 2019 is .03.

The proportion of twin births during Jan 2018 to Jan 2019 is .04.

The probability of twin births among the general population is .03.

The probability of twin births among the general population is .04.

Pr(observing a sample proportion of twin births from a random sample of 10,000 live births <= 0.04) = 0.03.

Pr(observing a sample proportion of twin births from a random sample of 10,000 live births <= 0.04) = 0.5.

Pr(observing a sample proportion of twin births from a random sample of 10,000 live births <= 0.03) = 0.04.

Pr(observing a sample proportion of twin births from a random sample of 10,000 live births <= 0.03) = 0.5.

• 1

You're entering records into a database, and you realize you don't have the information for one of the fields. What do you do?

Use letters in alphabetical order to select options

1. A

In the Field Properties section, change the Required field to Blank so users can skip the field during data entry.

2. B

Unless a field's set up to require an entry, you can skip the fields for which you don't have any data.

3. C

In order for a user to leave a field blank, you'd have to set its data type to Optional so that data entry personnel can skip it.

4. D

Access doesn't allow blank fields, so you have to wait until you have all the fields' data before you can enter that record.

2

Which data type would you use for a field that will contain phone numbers?

Use letters in alphabetical order to select options

1. A

Number.

2. B

Hyperlink.

3. C

Short Text.

4. D

AutoNumber.

3

On which Ribbon tab will you find tools for starting a new table?

Use letters in alphabetical order to select options

1. A

The Database Tools tab contains the Create Table button.

2. B

The Create tab contains the Table and Table Design buttons.

3. C

The Design tab contains the Design Table button.

4. D

The File tab contains the New Table command.

4

What are the benefits of using validation rules?

Use letters in alphabetical order to select options

1. A

They reduce typos, create a consistent look for reports, and make searching easier.

2. B

They make data entry go faster by inserting a value automatically into the field, and they make it easier to set up reports that must include a lot of information on a single sheet of paper.

3. C

They eliminate duplicate entries in records that must remain unique, and they speed up the data entry process.

4. D

They prevent duplicate values in more than one field in the table, which makes it easier for Access to sort your records.

5

How do you control the way Access stores and displays a date in a table field?

Use letters in alphabetical order to select options

1. A

Type MMDDYYYY into the Validation Rule row under Field Properties.

2. B

Use the Format setting under Field Properties, and choose a format from the drop-down menu.

3. C

Type Short or Long, the two date format options, into the Format row under Field Properties.

4. D

Type Short Date in the Field Size setting under Field Properties.

6

When you're ready to go back to work on a database you used earlier in the day, what's the quickest way to find and reopen it?

Use letters in alphabetical order to select options

1. A

Click the File tab, and click the Open command to display your most recently used database files.

2. B

Click the Home tab, click the View button's drop-down menu, and choose View Recent Files.

3. C

Click the Open button on the Quick Access Toolbar.

4. D

Click the File tab and see the file listed in the menu, or click Recent to display a list of recently used databases.

7

Which data types can you apply to the primary key in your Access tables?

Use letters in alphabetical order to select options

1. A

Primary key fields can use AutoNumber or Text data types, but they can't use Memo data types.

2. B

Any data type other than Memo is acceptable for a primary key.

3. C

The default is AutoNumber, but any data type that allows a user to enter unique data into that field is acceptable.

4. D

All primary keys use the AutoNumber data type because it's the only one that allows unique data entry.

8

How do you display your tables' fields so you can establish relationships between tables in your database?

Use letters in alphabetical order to select options

1. A

On the Database Tools tab, click the Object Dependencies button to display a list of all the table fields in your database.

2. B

On the Create tab, click the Relationships button. From there, you can select the tables in your database from the drop menu and view their fields.

3. C

On the Database Tools tab, click the Relationships button, and use the resulting Show Table dialog box to display a field list box for each table in your database.

4. D

Open all your tables in datasheet view, and use your mouse to drag the field names from one table to another.

9

What's the easiest way to rename a field?

Use letters in alphabetical order to select options

1. A

Open the table in design view, click the current name in the Field Name column, and edit it there.

2. B

The only field you can rename is the default ID field by adding text in front of the letters "ID" to customize the primary key.

3. C

In the Table Tools tab, click the Insert Rows button, enter the desired field name into the new row, and then use the Delete Row button to remove the one with the incorrect name.

4. D

You can't rename fields once you've created them. All you can do is delete them and create a new field with the name you wanted to use.

10

When you work with a form, as many as five arrow buttons may appear near the bottom left corner of your form. Which of these buttons can you always use to go to the last record in your table?

Use letters in alphabetical order to select options

1. A

The second button, which looks like a left arrow.

2. B

The fourth button, which looks like a right arrow pointing to a vertical line.

3. C

The first button, which looks like a left arrow pointing at a line.

4. D

The third button, which looks like a right arrow.

What is meant by “non-drug” and “non-health” interventions and why are these types of interventions necessary to reduce the harmful effects of substance use and abuse in populations?

What is meant by “non-drug” and “non-health” interventions and why are these types of interventions necessary to reduce the harmful effects of substance use and abuse in populations?

Trace the meaning of the different terms and concepts: non-governmental, non-profit, and faith-based.

Give a numerical example of non routine decision, Determine the relevant costs for this non routine decision and discuss the analysis (quantitative and qualitative) required to make the decision ( Numerical example)

Let X be a non-degenerate ordered set with the order topology. A non-degenerate set is a set with more than one
element.

Show the following:

(1) every open interval is open, (2) every closed interval is closed, (3) every open
ray is open, and (4) every closed ray is closed.

Please note: Its a topology question.

Please assist with the following:

The Philadelphia Phillies defeated the Tampa Bay Rays 4 to 3 to win the 2008 major league baseball World Series (The Philadelphia Inquirer, October 29, 2008). Earlier in the major league baseball playoffs, the Philadelphia Phillies defeated the Los Angeles Dodgers to win the National League Championship, while the Tampa Bay Rays defeated the Boston Red Sox to win the American League Championship. The file MLBSalaries contains the salaries for the 28 players on each of these four teams (USA Today Salary Database, October 2008). The data, shown in thousands of dollars, have been ordered from the highest salary to the lowest salary for each team.

1. Analyze the salaries for the World Champion Philadelphia Phillies. What is the total payroll for the team? What is the median salary? What is the five-number summary?

2. Were there salary outliers for the Philadelphia Phillies? If so, how many and what were the salary amounts?

3. What is the total payroll for each of the other three teams? Develop the five-number summary for each team and identify any outliers.

4. Show the box plots of the salaries for all four teams. What are your interpretations? Of these four teams, does it appear that the team with the higher salaries won the league championships and the World Series?

MLB Salaries: