MANG 341-A large wedding planning company, Weddings

Complete the following homework in a Word or PDF document and upload it to the dropbox.1) A large wedding planning company, Weddings Just for You, has collected some information from a random sample of weddings they have planned throughout the United States last year to get an idea of the state of their business. This information is included in the sheet “Weddings” in the Excel file. The data is shown in thousands of dollars. They want to use an alpha level of 0.05.a. First, they would like to know if the average budget for the weddings they plan is the same as the national average of $23,000. (Include a 7 step analysis, use the below graph for step 4).b. Second, their goal is to have the average actual spending be less than or equal to the budget for the weddings. They want to know if they are meeting this goal. They assume the variance of the budget and spending are equal. (Include a 7 step analysis, use the below graph for step 4).2) The Tall Log Logging Company is scouting out two different locations for their next logging site. Both sites are the same size and have similar characteristics. Therefore, average tree height is the main factor in their decision of site A or B. However, site A is slightly closer to the main road. Therefore, the only reason they would chose site B is if the average tree height is greater than site A. They took a random sample of tree heights at each site which is included in the sheet “Trees” in the Excel file. Assuming we know the standard deviation of the tree heights in both forests is 15.5 feet and using an alpha level of 0.03, which site should they choose? (Include a 7 step analysis, use the below graph for step 4.)Wedding Budget($1000’s) Acutal Spending($1000’s)1924.351014.851319.952127.953134.951823.551821.751520.951722.151521.652127.551014.452125.455561.952732.553034.651721.751316.852632.652833.952831.954248.451925.853135.25 Height of trees (feet)Site ASite B90118113769912511111198811021191061009211311012211089819111682941061071237010612011578113959612710811784879112711810590102971168086821081061171267510074115