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...

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 study was conducted to investigate the influence of a driver's
age, number of driving years and attention span (the higher, the
more detailed) on the number of speeding tickets within the last
five years. Given a driver at age 30, who has been driving for 10
years with an attention span score of 5, what is the number of
tickets that can be expected?
TICKETS
AGE
YEARS
SPAN
8
32
16
7
6
35
19
10
5
24
10...

Hudson Marine has been an authorized dealer for C&D marine
radios for the past seven years. Suppose the quarterly sales values
for the seven years of historical data are as follows.
Year
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total Yearly
Sales
1
7
13
9
4
33
2
11
20
16
6
53
3
12
25
25
11
73
4
18
28
26
16
88
5
23
35
27
21
106
6
24
37
31
18
110
7...

The table below shows average daily sales of Rice Krispies in
the month of June in 74 Noodles & Company restaurants. Use the
following data set and answer the questions
32
8
14
20
28
19
37
31
16
16
16
29
11
34
31
18
22
17
27
16
24
49
25
18
25
21
15
16
20
11
21
29
14
25
10
15
8
12
12
19
21
28
27
26
12
24
18
19
24
16...

Choose either column D or E of the attached data set and analyze
using the techniques discussed in class up to this point. This
includes the following:
Find the appropriate measure of center. Discuss why the chosen
measure is most appropriate. Why did you decide against other
possible measures of center?
Find the appropriate measure of variation. The measure of
variation chosen here should match the measure of center chosen in
Part 1.
Find the graph(s) needed to appropriately describe...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 2 minutes ago

asked 2 minutes ago

asked 3 minutes ago

asked 3 minutes ago

asked 7 minutes ago

asked 8 minutes ago

asked 8 minutes ago

asked 10 minutes ago

asked 12 minutes ago

asked 12 minutes ago

asked 16 minutes ago

asked 18 minutes ago