We have a large data project with data that is structered in the same way in each excel file.
We would need a relatively simple macro to do several things automatically.
We want to compare averages and test for statistical significance. We provide the formulas and illustrate clearly what has to be created.
The macro should be able to do among other things:
Filter data on a prespecified value
Add columns with averages
Calculate standard errors & test for signficance (we provide formulas)
Create a table in a different layout
I created an example excel sheet which discusses the 6 necessary steps.
We would probably need 4 macro's because of slightly different base files.
I can't upload an excel file here because of confidentiality reasons but you can contact me directly to discuss further.
49 freelancer đang chào giá trung bình €357 cho công việc này
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy
Hi Greetings of the day.I am Akriti.I have done my bachelors in computer science.I can help you in this project.I am an Excel vba pro and for skills you can have a look over my reviews. Regards