Normalize the following data by:

a) identifying the functional dependencies,

b) stating your assumptions, \

c) creating relations, and

d) identifying primary and foreign keys.

Customer Number| First Name |Last Name |Phone | Invoice Number| Date |Item Type |Quantity Item Price

a. If ? ~ ?(?,?), find the distribution (name and parameters) of ?=?X+?.

b. If ?~?(0,?), find the density of ?=|?|.

c. If ? ~ ?amma(?,?), find the distribution (name and parameters) of ?=?X.

d. If ? ~ Uniform(0,1), find the density function of ?=√?.

e. If Θ ~ Uniform(−?/2,?/2), find cdf and the density function of ?=tan(Θ).

Show ALL work if it is required for the question and BASES

7. Name 3 components of the CPU and the Buses. Describe what they do.

8. Name 4 essential status flags and describe what they do.

9. Translate this Expression to Assembly: EAX = -val2 + 7 - val3 + val1

c program

//the file's size in bytes
unsigned int fileSize(const char* name){
    return 0;
}

//same as fileSize except if the file is a directory then it recursively finds the size of directory and all files it contains
unsigned int fileSizeRec(const char* name){
    return 0;
}

using matlab:

1- Using ‘input’ command, ‘prompt’ your name and ask for a grade (A, B, C, D, F should be accepted only, otherwise it should ask again)

2- Use ‘display’ command for the previous problem and display your name and your grade

QUESTION 1

1. Assume that the two samples of five cereal boxes (one sample for each of two cereal varieties) listed on the TCCACCTC Web site were collected randomly by organization members. For each sample, assume that the population distribution of individual weight is normally distributed, the average weight is indeed 368 grams and the standard deviation of the process is 15 grams, and obtain the following using Excel and PHStat:

   Weights of Oxford O’s boxes
   360.4
   361.8
   362.3
   364.2
   371.4
   
   Weights of Alpine Frosted Flakes with Vitamins & Minerals boxes
   366.1
   367.2
   365.6
   367.8
   373.5 All answers should be accurate to 2 decimal places.

2. (a) For the Oxford's O:

      (i) The value of the sample mean =

      (ii) The proportion of all samples for each process that would have a sample mean less than the value you calculated in step (a)(i) =

      (iii) The proportion of all the individual boxes of cereal that would have a weight less than the value you calculated in step (a)(i) =

      (iv) The probability that an individual box of cereal will weigh less than 368 grams =

      (v) The probability that 4 out of the 5 boxes sampled will weigh less than 368 grams =

      (vi) The lower limit of the 95% confidence interval for the population average weight =

      (vii) The upper limit of the 95% confidence interval for the population average weight =

   (b) For the Alpine Frosted Flakes:

      (i) The value of the sample mean =

      (ii) The proportion of all samples for each process that would have a sample mean less than the value you calculated in step (b)(i) =

      (iii) The proportion of all the individual boxes of cereal that would have a weight less than the value you calculated in step (b)(i) =

      (iv) The probability that an individual box of cereal will weigh less than 368 grams =

      (v) The probability that 4 out of the 5 boxes sampled will weigh less than 368 grams =

      (vi) The lower limit of the 95% confidence interval for the population average weight =

      (vii) The upper limit of the 95% confidence interval for the population average weight =

QUESTION 2

1. Oxford Cereals then conducted a public experiment in which it claimed it had successfully debunked the statements of groups such as the TriCities Consumers Concerned About Cereal Companies That Cheat (TCCACCTC) that claimed that Oxford Cereals was cheating consumers by packaging cereals at less than labeled weights. Review the Oxford Cereals' press release and supporting documents that describe the experiment at the company's Web site and then answer the following assuming that now you have no information about the mean and standard deviation of the population distribution of the weight of all boxes of the cereal produced:

   Weight
   351.8
   360.65
   372.74
   382.96
   375.28
   352.16
   374.15
   361.8
   366.67
   398.86
   384.34
   367.53
   361.59
   364.47
   382.93
   366.88
   368.14
   408.19
   356.03
   379.27
   380.38
   386.44
   378.72
   342.05
   380.29
   361.1
   355.11
   387
   346.86
   391.94
   366.3
   350.52
   397.27
   349
   373.78
   384.04
   392.55
   361.98
   377.07
   390.88
   395.86
   370.21
   380.66
   389.33
   361.15
   386.74
   353
   354.22
   374.24
   363.77
   352.08
   364.11
   359.79
   367.12
   375.84
   343.29
   357.7
   384.75
   380.72
   356.22
   389.72
   375.28
   380.44
   379.14
   364.64
   379.63
   369.29
   337.1
   371.42
   347.63
   363.86
   381.28
   379.21
   366.26
   365.15
   351.33
   375.91
   363.32
   357.96
   375.58

   All answers should be accurate to 2 decimal places.

   (a) For a two-tailed t-test on whether the population mean weight is equal to 368g:

      (i) The value of the t-test statistic is =

      (ii) The p-value of the t-test statistic is =

      (iii) The lower-critical value is =

      (iv) The upper-critical value is =

   (b) For an upper-tailed t-test on whether the population mean weight is more than 368g:

      (i) The value of the t-test statistic is =

      (ii) The p-value of the t-test statistic is =

      (iii) The upper-critical value is =

   (c) For the 95% confidence interval for the population average weight:

      (i) The lower limit =

      (ii) The upper limit =

NOTE: THIS IS ALL INFORMATION PROVIDED

Eric Mendes and Becky Conners, each age 42, married on September 7, 2016. Eric and Becky will file a joint return for 2018. Eric’s Social Security number is 444-55-6667. Becky’s Social Security number is 321-21-4321. Becky adopted Mendes as her married name. They live at 4450 Emerald Street, Los Angeles, California 90032.

Eric divorced his former wife, Sara Mendes, in March of 2016. Under the divorce agreement Eric pays Sara $1,250 per month for the next 10 years or until Sara’s death, whichever comes first. During 2018, Eric made all twelve payments to her. In addition, Eric paid Sara $22,000 which is designated as being for her share of the marital property. Eric and Sara had no children. Sara’s Social Security number is 677-76-9292.

Eric’s 2018 salary is $150,000. He is an executive working for Maple Manufacturing Company. As part of his compensation package, Maple provides him with group term life insurance equal to twice his annual salary. His employer withheld $25,000 for federal income taxes and $8,500 for California income taxes.

Becky recently graduated from law school and is employed by the law firm of Davis and Davis. She received a salary of $85,000 in 2018. Her employer withheld $9,000 for federal income taxes and $4,000 for California income taxes.

Eric and Becky had $550 of interest income from Bank of America. They received a $1,900 refund on their 2017 California income tax return during the year. They itemized deductions during 2017 (itemized deductions exceeded their standard deduction by $600). During 2018 they paid $7,200 of mortgage interest and $8,000 of property taxes on their personal residence. They made charitable cash contributions of $1,800 to their church during 2018. Both spouses had health insurance the entire year and do not want to contribute to the Presidential Election Campaign.

Prepare Eric and Becky’s 2018 federal income tax return. Part of your assignment is to select the forms necessary to prepare this income tax return. Forms are available at IRS.gov

Alfred E. Old and Beulah A. Crane, each age 42, married on September 7, 2016. Alfred and Beulah will file a joint return for 2018. Alfred’s Social Security number is 111-11- 1112. Beulah’s Social Security number is 123-45-6789, and she adopted “Old” as her married name. They live at 211 Brickstone Drive, Atlanta, GA 30304.

Alfred was divorced from Sarah Old in March 2016. Under the divorce agreement, Alfred is to pay Sarah $1,250 per month for the next 10 years or until Sarah’s death, whichever occurs first. Alfred pays Sarah $15,000 in 2018. In addition, in January 2018, Alfred pays Sarah $50,000, which is designated as being for her share of the marital property. Also, Alfred is responsible for all prior years’ income taxes. Sarah’s Social Security number is 123-45-6788.

Alfred’s salary for 2018 is $150,000, and his employer, Cherry, Inc. (Federal I.D. No. 98-7654321), provides him with group term life insurance equal to twice his annual salary. His employer withheld $24,900 for Federal income taxes and $8,000 for state income taxes. The proper amounts were withheld for FICA taxes. Beulah recently graduated from law school and is employed by Legal Aid Society, Inc. (Federal I.D. No. 11-1111111), as a public defender. She receives a salary of $42,000 in 2018. Her employer withheld $7,500 for Federal income taxes and $2,400 for state income taxes. The proper amounts were withheld for FICA taxes.

Alfred and Beulah had interest income of $500. They receive a $1,900 refund on their 2017 state income taxes. They itemized deductions on their 2017 Federal income tax return (total of $15,000). Alfred and Beulah pay $4,500 interest and $1,450 property taxes on their personal residence in 2018. Their charitable contributions total $2,400 (all to their church). They paid sales taxes of $1,400, for which they maintain the receipts. Both spouses had health insurance for all months of 2018 and do not want to contribute to the Presidential Election Campaign. Compute the Olds’ net tax payable (or refund due) for 2018. If you use tax forms for your solution, you will need Form 1040 and Schedules A