Question

**Convert the Ch01_SalesSummary file to a database table
in MS Access (steps: drop unnecessary titles row and import data
into Access using “External Data” Excel tab in Access). Sort the
new Access database table in ascending order by any one
column.**

Table | Waitstaff | Member# | #Guests | Hour | Food | Beverage | Total |

29 | WH | 0 | 1 | 8 | 0 | 4 | 5 |

28 | MM | 101 | 4 | 8 | 0 | 4 | 5 |

28 | MM | 0 | 2 | 8 | 5 | 8 | 15 |

5 | LR | 0 | 2 | 8 | 5 | 9 | 16 |

30 | WH | 123 | 2 | 8 | 12 | 10 | 25 |

21 | MM | 117 | 4 | 8 | 9 | 16 | 28 |

23 | MM | 0 | 3 | 8 | 22 | 21 | 43 |

20 | MM | 0 | 4 | 8 | 24 | 20 | 44 |

6 | LR | 0 | 1 | 9 | 0 | 5 | 8 |

18 | LR | 104 | 2 | 9 | 16 | 20 | 36 |

15 | LR | 0 | 2 | 9 | 9 | 18 | 29 |

30 | WH | 0 | 2 | 9 | 8 | 7 | 17 |

30 | WH | 0 | 2 | 9 | 4 | 13 | 19 |

14 | LR | 0 | 2 | 9 | 5 | 16 | 21 |

5 | LR | 111 | 2 | 9 | 11 | 12 | 23 |

30 | WH | 0 | 1 | 9 | 0 | 8 | 8 |

21 | MM | 121 | 4 | 9 | 26 | 24 | 50 |

5 | LR | 0 | 3 | 9 | 16 | 17 | 33 |

26 | MM | 0 | 4 | 9 | 32 | 40 | 72 |

20 | MM | 0 | 2 | 9 | 12 | 18 | 30 |

23 | MM | 0 | 2 | 9 | 10 | 11 | 21 |

20 | MM | 101 | 4 | 10 | 26 | 36 | 62 |

30 | WH | 0 | 2 | 10 | 0 | 10 | 10 |

23 | MM | 0 | 2 | 10 | 17 | 16 | 33 |

6 | LR | 0 | 4 | 10 | 20 | 16 | 36 |

14 | LR | 0 | 1 | 10 | 0 | 8 | 10 |

31 | WH | 106 | 1 | 10 | 0 | 3 | 6 |

23 | MM | 0 | 2 | 10 | 18 | 12 | 30 |

21 | MM | 0 | 4 | 10 | 18 | 40 | 58 |

15 | LR | 0 | 2 | 10 | 7 | 12 | 19 |

28 | MM | 120 | 1 | 10 | 0 | 5 | 7 |

6 | LR | 0 | 2 | 10 | 10 | 20 | 30 |

31 | WH | 0 | 1 | 10 | 6 | 4 | 10 |

29 | WH | 0 | 1 | 11 | 0 | 10 | 10 |

27 | MM | 0 | 2 | 11 | 9 | 12 | 21 |

15 | LR | 0 | 3 | 11 | 11 | 24 | 35 |

26 | MM | 115 | 4 | 11 | 15 | 25 | 40 |

23 | MM | 0 | 4 | 11 | 36 | 12 | 48 |

21 | MM | 0 | 4 | 11 | 22 | 43 | 65 |

16 | LR | 0 | 2 | 11 | 6 | 10 | 16 |

20 | MM | 0 | 5 | 11 | 23 | 50 | 73 |

6 | LR | 0 | 2 | 11 | 6 | 8 | 14 |

14 | LR | 0 | 2 | 12 | 6 | 10 | 16 |

5 | LR | 0 | 4 | 12 | 13 | 28 | 41 |

27 | MM | 109 | 4 | 12 | 12 | 12 | 24 |

18 | LR | 118 | 3 | 12 | 15 | 24 | 39 |

23 | MM | 0 | 2 | 12 | 18 | 20 | 38 |

20 | MM | 0 | 4 | 12 | 22 | 32 | 54 |

16 | LR | 0 | 2 | 12 | 0 | 6 | 6 |

30 | WH | 0 | 1 | 12 | 0 | 5 | 7 |

Answer #1

Step-by-Step procedure:

1. First bring data in to excel file.

2.Save the file in your local drive as
"**Ch01_SalesSummary".**

**3. Open MS access blank database .(if you open ms
access, the system will ask to open as blank database)**

4. click that and create a database.

5.Select "External data" option in the top of the ribbon and goto " new data source" option --> From file --> excel

6.

7.

8.

Here do not import option is there.. you can use that option to exclude the columns.

DAta type also you can fix based on the header and type of the data.

Primery key wil lbe fixed in this step.

Ascending or descending through any colums.

6. Using the class data (see Blackboard file - "Class Survey
Data - PSS-10 and GAS") calculate the correlation between the GAS –
Goal disengagement and the GAS – Goal reengagement scores. Write
the results in a statistical statement.
7. Using the class data calculate the correlation between the
GAS – Goal disengagement and the PSS-10 scores. Write the results
in a statistical statement.
8. Using the class data calculate the correlation between the
GAS – Goal reengagement scores and...

The results of a sample of 372 subscribers
toWiredmagazine shows the time spent using the Internet
during the week. Previous surveys have revealed that the population
standard deviation is 10.95 hours. The sample data can be found in
the Excel test data file.
What is the probability that another sample of 372 subscribers
spends less than 19.00 hours per week using the Internet?
Develop a 95% confidence interval for the population mean
If the editors of Wiredwanted to have the...

____________________________________________
The results of a sample of 372 subscribers to Wired
magazine shows the time spent using the Internet during the week.
Previous surveys have revealed that the population standard
deviation is 10.95 hours. The sample data can be found in the Excel
test data file.
What is the probability that another sample of 372 subscribers
spends less than 19.00 hours per week using the Internet?
____________________________________________
Develop a 95% confidence interval for the population mean
____________________________________________
If the editors...

Assuming that the population standard deviation is
unknown, calculate the 95% confidence interval of the
population mean.
The following is the data. Calculating Process should be shown
by Excel (Formulas). What formulas in statistics are used?
7
21
23
24
18
16
2
19
11
6
3
13
17
9
5
12
13
17
4
14
15
25
12
24
22
14
14
20
15
11
26
17
21
11
4
13
16
14
13
14
25
23
9
15...

A manufacturing company is purchasing metal pipes of standard
length from two different suppliers, ABC and XYZ. In the past two
months there are increasing complaints by the Production Manager
that delivery times by ABC present higher variability in comparison
to the delivery times by XYZ. The Production Manager is worried
that this variability will make it harder to efficiently schedule
the production process. If the variance of XYZ remains unchanged,
what should be the variance of ABC in order...

A manufacturing company is purchasing metal pipes of standard
length from two different suppliers, ABC and XYZ. In the past two
months there are increasing complaints by the Production Manager
that delivery times by ABC present higher variability in comparison
to the delivery times by XYZ. The Production Manager is worried
that this variability will make it harder to efficiently schedule
the production process.
Does the sample data indicate a statistically significant
difference at the 5% level? Justify your answer....

A manufacturing company is purchasing metal pipes of standard
length from two different suppliers, ABC and XYZ. In the past two
months there are increasing complaints by the Production Manager
that delivery times by ABC present higher variability in comparison
to the delivery times by XYZ. The Production Manager is worried
that this variability will make it harder to efficiently schedule
the production process. Does the sample data indicate a
statistically significant difference at the 5% level? Justify your
answer....

A company has the following returns over the past 30 months:
Month Ret.(%) Month Ret.(%) Month Ret.(%)
1) 3 11 -3 21 -1
2) -16 12 -2 22 -24
3) 31 13 -8 23 -14
4) 33 14 2 24 -19
5) -23 15 35 25 -19
6) -17 16 11 26 33
7) 8 17 -20 27 -18
8) -19 18 15 28 23
9) -13 19 -12 29 6
10 -17 20 17 30 5
What is...

I need a breakdown to perform in excel for numbers 7,8,9. I am
unsure of how I calculate the times. heres the data set and the
questions.
Calculate the probability that a flight will depart early or on
time.
Calculate the probability that a flight will arrive late.
Calculate the probability that a flight departs late or arrives
early.
DEP_Delay
ARR_Delay
-4
0
-3
-3
0
-5
-7
-1
8
3
-1
-5
3
8
11
6
-6
0
-5...

Part A. In the past it has been found that the arrival time have
a population mean value of μ = 13 and a population standard
deviation of σ = 6.26. Using the given data, test whether this mean
has changed. Use the critical value approach to test the
hypothesis. The significance level alpha is set at 0.05 . The
original data of time taken is given below. Show the process by
using excel (Formulas).
Part B. Test the hypothesis...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 38 minutes ago

asked 45 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago